I didn't explain that very well, sorry! Each sheet is as follows:

A B
C
1 Date Miles Cost
2 01/04/06 800 £320.00
3 02/04/06 100 £40.00
4 03/04/06 150 £52.50
5 04/04/06 100 £25.00

The rates are 40p up to 1000 miles and 25p for all miles after that. C2 is
800 * 40p, C3 is 100 * 40p, C4 puts me over the thousand, so it would be 100
* 40p and 50 * 25p. The miles travelled for the remainder of the year would
be at 25p, as the thousand miles mark has been passed.

I want to be able to just enter the date and amount of miles each day and
the formula in column c to work out the amount to claim. The formula will
need to look at all miles travelled in previous days/months then revert to
25p once the limit has been reached. Hope this makes more sense?

--
Cheers

Becks


"john" wrote:

do you mean 40p for the first 100 miles not 10000 miles? if so try
=IF(A1100,(100*B1)+C1*(A1-100),B1*A1) with the miles in A1, 40p in B1 and
25p in C1
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"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