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