SOLVED

MATHS FORMULA

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?

6 Replies

@GILLY440 

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

@GILLY440 

 

=(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)

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)
Solution

@GILLY440 

 

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