How to work out price per mile - SaabCentral Forums
Home Saab Pictures Saab Classifieds Saab Dealer Listings Saab Forum Saab Forum

Go Back   SaabCentral Forums > Saab Cafe > The Lounge

The Lounge For general discussions is the premier Saab Forum on the internet. Registered Users do not see the above ads.
Thread Tools Display Modes
Old 14th March 2007
mjl mjl is offline
Active Member
Join Date: Jan 2004                                                
Location: Tring - Hertfordshire
My Saabs: 1999 95 Estate SE
Posts: 31
Lightbulb How to work out price per mile

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

Reply With Quote Quick reply to this message
Sponsored Links
Old 14th March 2007
SMHarman SMHarman is offline
Saab Lunatic
Join Date: Jan 2006                                                
Location: Hoboken NJ
My Saabs: '03 9-3SS Vector
Posts: 2,883

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.
Reply With Quote Quick reply to this message
Old 14th March 2007
omegajb's Avatar
omegajb omegajb is offline
Saab Crazy
Join Date: Jul 2004                                                
Location: Washington DC
My Saabs: 2004 9-3 Arc
Posts: 601

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.
Reply With Quote Quick reply to this message
Old 15th March 2007
unkleG'sif's Avatar
unkleG'sif unkleG'sif is offline
Saab Lunatic
Join Date: Sep 2004                                                
Location: Liverpool, UK
My Saabs: 1993 T16 (xLPT) - 1994 RUBY!!!
Posts: 3,470

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

"we can allow satellites, planets, suns, universe, nay whole systems of universe[s,] to be governed by laws, but the smallest insect, we wish to be created at once by special act" - Charles Darwin
Reply With Quote Quick reply to this message
Old 15th March 2007
cdaly's Avatar
cdaly cdaly is offline
Join Date: Dec 2003                                                
Location: Dublin, Ireland
My Saabs: '92 900LPT, '90 900i vert
Posts: 4,637

MPG / 4.54 = MPL (miles per litre)
MPL * distance = litres
litres * price per litre = "oh ****, I'm sorry I asked!..."
Reply With Quote Quick reply to this message
Sponsored Links


Quick Reply

Register Now

In order to be able to post messages on the SaabCentral Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
Please enter a password for your user account. Note that passwords are case-sensitive.
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:


Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2015, vBulletin Solutions, Inc.

top of page | sitemap | email us

copyright © 2003 - 2011, All rights reserved - valid xhtml - valid css
SaabCentral is an independently run website and is not affiliated in any way to Saab Automobile AB.

Garage Plus vBulletin Plugins by Drive Thru Online, Inc.