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).

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
--
paul
remove nospam for email addy!



"Ann Cardus" wrote:

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).

On Tue, 16 Aug 2005 02:15:02 -0700, "Ann Cardus"
wrote:

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

Why so many sig figs! OP will not be interested in the last nanometre he
gets from a gallon!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ron Rosenfeld" wrote in message
...
On Tue, 16 Aug 2005 02:15:02 -0700, "Ann Cardus"
wrote:

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

On Tue, 16 Aug 2005 10:36:37 -0300, "Bernard Liengme"
wrote:

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