Forum Discussion
Solved
Formula
| MILEAGE | LITRES ISSUED | FUEL CONSUMPTION | |||||
| Current Mileage | Last Mileage | Distance Travelled | Diesel | Petrol | Actual | Standard | Variance |
| 325654 | 325164 | 490 | 51.25 | 9.56 | 10.00 | -0.44 | |
| 3215 | 3175 | 40 | 10 | #DIV/0! | #DIV/0! | ||
I need a formula for the Actual fuel consumption column, where it will calculate the consumption whether I enter Litres Issued in the Petrol or Diesel column. Distance travelled is Column F, Diesel is Column G, Petrol is Column H, and Actual is column I
In I3:
=IFERROR(F3/MAX(G3:H3), "")
In K3:
=IF(I3="", "", I3-J3)
2 Replies
In I3:
=IFERROR(F3/MAX(G3:H3), "")
In K3:
=IF(I3="", "", I3-J3)
HansVogelaar thank you very much
