Forum Discussion
Excel Formula
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
I assume you mean Liters/100 km.
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.
