> or < Than

[Kev]

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.

 

[Andrew Taylor]

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

 

[ERR229]

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