# Calculating Mileage rates based on different rates depending on cumulative miles travelled

1. ## Calculating Mileage rates based on different rates depending on cumulative miles travelled

Hi

Was looking for some help if anybody has any ideas?

I am currently working on building a spreadsheet that will calculate mileage rate depending on what miles (cumulative) have been traveled per month. I have got the nested formula working but it is calculating the cost on the cumulative figure and not the actual mileage traveled for the particular month.

I have spent alot of time but cannot get it to calculate on the individuals month total. I think i need to add into the formula to minus previous cumalative figure from current and multiply(taking into consideration all the rates that could be applicable to the total mileage)

Thanks
M  Register To Reply

2. ## Re: Calculating Mileage rates based on different rates depending on cumulative miles trave

J8=\$B8*VLOOKUP(\$C8,\$K\$4:\$L\$7,2,1) and drag down.  Register To Reply

3. ## Re: Calculating Mileage rates based on different rates depending on cumulative miles trave

The intended result is as follows

D8 calculated total should be .45 (1 * .4479)
D9 calculated totals should be 672.10 (1499*.4479+ 1*.70)
D10 calculated total should be 2799.30 (3999*.70)

Thanks
Marie  Register To Reply