SOLVED

MATHS FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-2165141%22%20slang%3D%22en-US%22%3EMATHS%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165141%22%20slang%3D%22en-US%22%3E%3CP%3Egood%20morning%20all%2C%20i%20have%20a%20question%2C%20hopefully%20you%20may%20be%20able%20to%20help.%3C%2FP%3E%3CP%3Ei%20am%20charged%20%C2%A3285%20per%20mile%20for%20the%20first%20250%20miles%20then%200.45p%20per%20mile%20thereafter%3C%2FP%3E%3CP%3Eif%20we%20used%20480%20as%20an%20example%20what%20formula%20could%20i%20use%20to%20get%20my%20final%20cost%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2165141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2165189%22%20slang%3D%22en-US%22%3ERe%3A%20MATHS%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F978329%22%20target%3D%22_blank%22%3E%40GILLY440%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20really%20mean%20%3CSTRONG%3E%C2%A3285%20per%20mile%3C%2FSTRONG%3E%2C%20or%20should%20that%20be%20a%20flat%20fee%20of%20%C2%A3285%20for%20the%20first%20250%20miles%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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?

7 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
oh thanks!