=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.