One way:

A1: <km
A2: <l

A3: =CONVERT(A1,"km","mi")/CONVERT(A2,"l","gal")

or, equivalently

A3: =A1/A2 * 2.35265763970752

In article ,
"Terri" <robelg(at)mts(dot)net wrote:

Hello, I hope someone can help me. I am trying to make a spreadsheet to
figure out my miles per gallon on my new vehicle. The problem is ...I am
buying fuel by the liter and distance is in kilometers. I don't want
kilometers per liter, I would rather have miles per gallon.
Can anyone help me figure this out.
Thanks in advance,
Terri