f your figure of 10,000 is right, I imagine it refers to cumulative miles,
not to the single day's travel in isolation, which is what John's formula
deals with. So you need frst to add up cumuluative miles, say in column C
(add today's mles to yesterday's cumulative total from the cell above) and
then in the next column work out the day's reimbursement with the following
(where A20 is today's date, B20 is today's milage,and C20 is the cumulative
milage to date):
=IF(C20<10000;C20*0,4;4000)+(SE(C20<10000;0;(C20-10000)*0,25))-(SOMMA(D$14:D19))
Don't use this formula in the first row of the table (it will be self
referential), but simply calculate the first day's miles at 40 pence a mile.


"Becks" wrote:

I have a workbook with 12 sheets, each sheet represents a different month
where i record my mileage each day. Each sheet is set out as follows:

Date Miles Cost
01/04/06 800 £320.00

02/04/06 100 £40.00
03/04/06 150 £52.50
04/04/06 100 £25.00

I can claim 40p per mile for the first 10,000 miles, then it's 25p per mile
after that. I need a formula that will work out the amount i can claim for
each days travel based on the rates mentioned.

Can anyone help, i've been at this for ages and can't come up with anything
from my very limited knowledge???
--
Cheers

Becks