Will

=IF(SUM($B$2:B2)<1000,B2*0.4,IF(AND(SUM(B1:B2)100 0,SUM($B$1:B1)<1000),(SUM($B$2:B2)-1000)*0.25+(1000-SUM($B$1:B1)*0.4),B2*0.25))

Return what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Becks" wrote in message
...
I think that would give me my cost for a particular month, but i need a
seperate calculation for each day. Then when a new month begins i need
it
to do a calculation for each day of that month but also taking in to
account
the miles done in previous months?
--
Cheers

Becks


"Teethless mama" wrote:

=IF(SUM(B2:B100)<=10000,SUM(B2:B100)*0.4,10000*0.4 +(SUM(B2:B100)-10000)*0.25)

"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