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

@BZoup 

I assume you mean Liters/100 km.

HansVogelaar_0-1709766623912.png

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

=B1*100/B2*90%

Hi,

Yes that works, thanks for that.

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

@HansVogelaar