Hi Lynn,

Your display may indicate liters per 100 km. What car? USA USV or Japanese
1.0 litre?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"Lynn Q" wrote in message
...
Hi again,

Well, you know that was the formula I had except that I was using the
differential (c2-c1) in another column (d) and dividing that by the litres
in (b).

The vehicle in question tells me it's using 13 km/litre; whereas my
calculations are falling around 6.5. Odd, that.

So, any other ideas? Or is the vehicle display likely the error?

Thanks again.

Lynn

"Niek Otten" wrote in message
...
Hi Lynn,

With the kms in C and the Liters in B, the formula on line 2 should be:

=(C2-C1)/B2

Fill down as far as needed
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Lynn Q" wrote in message
...
Hi there,

Sorry, this is probably a dumb question, for which I apologise.

Anyway, need to know how to calculate a vehicle's usage of fuel, in
other words miles per gallon (kilometres per litre).

I have a spreadsheet that shows:
Date
Number of Litres to Fill
Reading (km) on each date
Total capacity of tank.

I want to see what the km/litre (mpg) is based on each fill-up.

I know what the number should be, but not how to tell Excel how to
calculate it. The numbers I get are out of whack.

Thanks!

Lynn