MATHS FORMULA

[GILLY440]

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?

[#2]

@GILLY440 

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

[#3]

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

[#4]

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

[#5]

Flat rate?$%&

not mentioned anywhere

=(480-250*0,45)+285 = 652,5

[#6 · Accepted 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.

[#7]

Fantastic, really appreciate your help

[#8]

oh thanks!