Different calculation value based on passing a total value

[ferrino]

Hi

I am trying to calculate the expense per mile for each journey, whilst all the while totalling total mileage. When the total reaches over 10,000 miles there is a different rate that is paid. I can do this where as soon as it tips over 10000 the new row in excel starts to calculate at the new rate, but the point it crosses needs to allow for 2 calculations - one at pre 10k miles and other at post 10k miles.

E.g. I have total of 9990 miles and do 20 miles. 10 miles should be calculated at pre rate 10 miles at post rate.

Any ideas how I can do this?

Thanks!

[ARGK]

Hi
Try this formula in cel G10 of your example and copy down.

=IF(E10<=10000,D10*0.45,IF(E10>10000,(10000*0.45+((E10-10000)*0.25))))

Good luck.
Tony