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