How to work out price per mile

[mjl]

Hi all you Excel types out there - little challenge for you.

I want to work out the price of a road trip in petrol, and have been struggerling to work out the required Excel formula. Any ideas anyone?

As my 9-5 show the mpg the first stage is to convert Litres to MPG and then allocate the price of each Ltr - then there must be a way of entering the distance covered and hopefully this'll give me the cost of petrol for the trip.

If someone could provide the formula or and explination of the maths it'll be good. So if anyone wants the challenge...please let me know

Or more simply can I set my display to read litres...

thanks in advance

Martin

[SMHarman]

Originally Posted by mjl

Or more simply can I set my display to read litres...

Yes you press two of the buttons on the SID controls at the same time. Should tell you which two in the handbook then you get to choose metric 1 or 2, Imperial and US. Metric 1 and 2 do litres.

[omegajb]

Microsoft Mappoint can do this as well. You tell it where you are going and the cost of fuel and it will calculate the totals for you.

[unkleG'sif]

if you know what you are getting in MPG, just divide it by 4.54 to get Miles Per Litre..... there are 4.54 litres to a Gallon..... easy peasy lemon squeezy

G

[cdaly]

MPG / 4.54 = MPL (miles per litre)
MPL * distance = litres
litres * price per litre = "oh ****, I'm sorry I asked!..."