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