Gas and milage formula not working out.

[hendrikbez]

Hello

Sorry for my English it is not my first language.

I have this file and the column KM/L and R cost per KM is not giving me the correct info.

I not always filling my car up with gas, as the prices changes quit here, so now it does not work the formula out right.

I put in the Liters put in, and when I full up again, then I put in the Odometer Reading

[sglife]

Would you please tell us what is the correct info you want.
I think you formulas are all correct and the result are correct too

[hendrikbez]

If you look at the entry of 02 sep 2008, the km/l amd "price of gas" does not look correct for me, Iam not always full up the car, so it should work it out for that also.

[davesexcel]

According to your data, you traveled more Km per liter than any other fill up.(11.5)
Your cost per km will then be less than other fill ups.