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