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