Forum Discussion
Solved
MATHS FORMULA
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?
With the distance in A1:
=285+MAX(A1-250,0)*0.45
This will work both for distances under and over 250 miles.
7 Replies
- oh thanks!
=(250*285)+((480-250)*0,45)
=71353,5
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Flat rate?$%&
not mentioned anywhere
=(480-250*0,45)+285 = 652,5
Do you really mean £285 per mile, or should that be a flat fee of £285 for the first 250 miles?
- Hi Hans
Flat rate of £285 for the first 250 miles then 45pence per mile added on thereafterWith the distance in A1:
=285+MAX(A1-250,0)*0.45
This will work both for distances under and over 250 miles.
