L/100 klms

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

I am trying to create a spreadsheet to help me work out the klms rating
of my van. I drove 1933.33 klms, used 187.626 liters and the van should
get 8.8/100 klms.
I would like to be able to compare another vehicle against the van by
entering it's ?/100 klms rating.
Does anyone know how I can do this.
Thanks
 
Hi Dale

With Kms in A1 and Liters in B1 enter in C1
=B1/(A1/100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top