That formula i have given you will take the said amount of miles in A1 and return 40p per mile for the first 10k and 25p per mile afterwards as one figure.
I used the formula i gave you in excel 2007 and below are the results i got.
5000 miles returns £2000 (5000 at 0.4)
9999 miles returns £3999.60 (9999 at 0.4)
10000 miles returns £4000 (10000 at 0.4)
10001 miles returns £4000.25 (10000 at 0.4 and 1 at 0.25)
15000 miles returns £5250 (10000 at 0.4 and 5000 at 0.25)
20000 miles returns £6500 (10000 at 0.4 and 10000 at 0.25)
Is this not what you were after?
Rob
Last edited by Rob82; 1st Jan 2010 at 20:06.