Convert litres per 100km to miles per gallon easily

[Guest]

I need to be able to set up a spreadsheet that allows users to type in a
figure for Litres per 100km (fuel consumption measure) and translate it into
a miles per gallon (UK measures) figure (fuel economy measure).

 

[Guest]

ok here is a long way to do it
say cell A1 is where you type your figure of l/100 k
in some other cell type this 100/A1*4.55*0.62
4.55 l per uk gallon.0.62 kilometer =mile.....
every time you type a figure in A1 the MPG displays in your other cell......
easy one to check me on is 10 l 100 ks,= 10 km litre =28.2 mpg

 

[Ron Rosenfeld]

I need to be able to set up a spreadsheet that allows users to type in a
figure for Litres per 100km (fuel consumption measure) and translate it into
a miles per gallon (UK measures) figure (fuel economy measure).

If you have the analysis toolpak installed, you could use this formula:

=convert(100,"km","mi")/convert(A1,"l","uk_pt")*8

If you do not have the ATP installed, you could use the following (more
obscure) formula:

=282.480661977632/A1



--ron

 

[Bernard Liengme]

Why so many sig figs! OP will not be interested in the last nanometre he
gets from a gallon!

 

[Ron Rosenfeld]

Why so many sig figs! OP will not be interested in the last nanometre he
gets from a gallon!

He is certainly free to use fewer sig figs! Although I prefer the figs that my
MIL grows in the Azores )

Actually, I prefer the CONVERT routine myself as it is essentially
self-documenting.


--ron