New Contributor

good morning all, i have a question, hopefully you may be able to help.

i am charged £285 per mile for the first 250 miles then 0.45p per mile thereafter

if we used 480 as an example what formula could i use to get my final cost?

7 Replies


Do you really mean £285 per mile, or should that be a flat fee of £285 for the first 250 miles?







I would be happy to know if I could help.



I know I don't know anything (Socrates)

Hi Hans
Flat rate of £285 for the first 250 miles then 45pence per mile added on thereafter
Flat rate?$%&

not mentioned anywhere

=(480-250*0,45)+285 = 652,5
best response confirmed by GILLY440 (New Contributor)



With the distance in A1:




This will work both for distances under and over 250 miles.

Fantastic, really appreciate your help
oh thanks!