Convert litres per 100km to miles per gallon easily

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"
<AnnCardus@discussions.microsoft.com> 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" <ronrosenfeld@nospam.org> wrote in message
news:k0n3g1d39hlbrpg0r01jfct89130uo5h7d@4ax.com...
> On Tue, 16 Aug 2005 02:15:02 -0700, "Ann Cardus"
> <AnnCardus@discussions.microsoft.com> 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"
<bliengme@stfx.TRUENORTH.ca> 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