Excel Formula

Copper Contributor

I'm trying to write a formula to calculate gas mileage.

eg; 6,469.26 Liters divided by 18.7 liters per Km = 345.94

      345.94 x 100 = 34,594 Km

      34,594 Km x 90% = 31,134.60 Km

2 Replies


I assume you mean Liters/100 km.


With liters in B1 and liters/100 km in B2, the formula is



Yes that works, thanks for that.

I was writing the formula wrong and not getting the results I was looking for.