Terri,

I've posted an example of how you might build your calculation on my web
site today. You can view it at http://www.pdbook.com.

Although the example calculates MPG per fuel purchase, you can easily modify
it to calculate average MPG over some range using the same logic.

Also, you might consider using JE's suggestion as the one formula involves
less steps.

----
Regards,
John Mansfield
http://www.pdbook.com

"Terri" wrote:

Thankyou to JE and John,
I tried John's but I got a different result than he. I got
1.6414892...instead of 23.52145845, not sure what I did. Then I tried JE's.
I had already started a spreadsheet and just added his formula
=A1/A2*2.35265763970752. (Just not sure what the 2.3526576370752 number
represents.) In my spreadsheet, I am trying to do an Average of miles per
gallon. Everytime I purchase fuel, I record the odometer reading, # of liters
, and $$ per liter. I think everything worked out ok, but not sure how to
figure out the first fuel purchase. Maybe I can send one of you the file, so
you can have a look at it.
Thanks, Terri

"JE McGimpsey" wrote:

One way:

A1: <km
A2: <l

A3: =CONVERT(A1,"km","mi")/CONVERT(A2,"l","gal")

or, equivalently

A3: =A1/A2 * 2.35265763970752

In article ,
"Terri" <robelg(at)mts(dot)net wrote:

Hello, I hope someone can help me. I am trying to make a spreadsheet to
figure out my miles per gallon on my new vehicle. The problem is ...I am
buying fuel by the liter and distance is in kilometers. I don't want
kilometers per liter, I would rather have miles per gallon.
Can anyone help me figure this out.
Thanks in advance,
Terri