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 c...
With the distance in A1:
=285+MAX(A1-250,0)*0.45
This will work both for distances under and over 250 miles.
=(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