# 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

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.

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

4. ## na

delete post

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1