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.