or < Than
 

Please Help
I'm Trying to do a mileage counter and I need to know the formula for cell
b57 if the first 10000 miles are charged at 40p and every mile after that at
25p. B57 is the counting cell for how many miles per week I do.

or < Than
 

=MIN(B57,10000)*0.4 + MAX(B57-10000,0)*0.25
should do it (gives the answer in £)




Kev wrote:
Please Help
I'm Trying to do a mileage counter and I need to know the formula for cell
b57 if the first 10000 miles are charged at 40p and every mile after thatat
25p. B57 is the counting cell for how many miles per week I do.

or < Than
 

If I'm understanding you issue correctly, try this:
=IF(B57<=10000,B57*0.4,B57*0.4+(B75-10000)*0.25)
--
ERR229


"Kev" wrote:

Please Help
I'm Trying to do a mileage counter and I need to know the formula for cell
b57 if the first 10000 miles are charged at 40p and every mile after that at
25p. B57 is the counting cell for how many miles per week I do.