Assistance - Correct formula to pull number from chart

[hipmrc]

Good morning all,

I am trying to populate G35 in my spreadsheet from a chart. You can see the chart here

[TABLE="width: 206"]
<tbody>[TR]
[TD="colspan: 2"]If Between[/TD]
[TD]Use[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5,000[/TD]
[TD]0.0195[/TD]
[/TR]
[TR]
[TD]5,001[/TD]
[TD]10,000[/TD]
[TD]0.0185[/TD]
[/TR]
[TR]
[TD]10,001[/TD]
[TD]20,000[/TD]
[TD]0.0175[/TD]
[/TR]
[TR]
[TD]20,001[/TD]
[TD]30,000[/TD]
[TD]0.0165[/TD]
[/TR]
[TR]
[TD]30,001[/TD]
[TD]40,000[/TD]
[TD]0.0155[/TD]
[/TR]
[TR]
[TD]40,001

[/TD]
[TD]and over

[/TD]
[TD]0.0145

[/TD]
[/TR]
</tbody>[/TABLE]
G36 will then = H26 (number of messages) Times one of the Use amounts (ex: H26 *.0185 - which on my spreadsheet will be H26*G35))

So, based on the total number of messages found in H26 I need Excel to select the correct corresponding Use amount from the chart to populate G35. So if H26 is 30,050 the correct Use number in G35 is .0155

Can someone please explain to me the correct formula to use? Right now I have the chart on a second page of the spreadsheet and plan to lock it and change text color to white to hide it.

Please let me know if you need any questions answered and thank you in advance for your assistance.

Michael
hipmrc

 

[hipmrc]

I am editing the chart to include 0

So the first entry would be if 0 use 0