same thing again...#value. the mileage cell has a number in it but its a
formula in itself, picking up the cumulative total of another group of cells
on a previous speadsheet page. would that be why. its all numbers in the end
though haha no extra text.

cheers
scott

"Ashish Mathur" wrote:

Hi,

Try this. Cell D4 holds 10000. Cell E4:E5 hold 0.40 and 0.25. Cell D8
contains the mileage

=IF(D8<=$D$4,D8*$E$4,($D$4*$E$4)+(D8-$D$4)*$E$5)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Scott Dann" <Scott wrote in message
...
hey :) i'm having problems with my little issue of calculating mileage
costs.

Basically I need to work out my mielage costs for a company i'm working
for
who ask that i will need to work out 40cents per mile for first 10,000
miles,
then 25 cents thereafter. eventually adding the whole lot up for one lump
sum

i'm not sure how to put that in formula form.

I managed the first half of it by multiplying the overall milage by 0.4.
but
how do i get it to detect when the mileage has reached 10,000 in order for
it
to recalculate at 0.25?