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.
Hi Hans
Flat rate of £285 for the first 250 miles then 45pence per mile added on thereafter
Flat rate of £285 for the first 250 miles then 45pence per mile added on thereafter
With the distance in A1:
=285+MAX(A1-250,0)*0.45
This will work both for distances under and over 250 miles.
- Fantastic, really appreciate your help