IF a range of number equals a set $value

[curts]

Hello,

I'm trying to figure out the formula for mile chart for our customers.. Please try and make it as simple as possible

What I'm trying to do is have it so the customer can just put in whatever mile they want, like 249 miles and it will pull the specific $ I have set in the C2 through C152

So 1 through 49 will pull the $405.39 or 90 through 99 will pull $447.62 and so on..

1 49 $405.39
50 59 $413.84
60 69 $422.28
70 79 $430.73
80 89 $439.17
90 99 $447.62

Thanks in advance

[Butcher1]

=INDEX(C1:C6,MATCH(E2,A1:A6,1))

Put your minimal mileage values in A1:A6.
Put your maximum mileage values in B1:B6.
Put your dollar value in C1:C6.
Put miles driven in E2.

Any mileage over 99 will still fall in you maximum dollar value.

[curts]

That worked perfectly Butcher1.. Thanks for the fast response..

[adhawan06]

Hi curts.

Welcome to the forum...

Glad our forum contributor helped you....

Don't forget to say thanks by adding *Add Reputation to the user who helped you. Also, take few seconds to mark this thread as SOLVED.