Forum Discussion
PierreK100
May 28, 2025Copper Contributor
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....
- May 28, 2025
In I3:
=IFERROR(F3/MAX(G3:H3), "")
In K3:
=IF(I3="", "", I3-J3)
HansVogelaar
May 28, 2025MVP
In I3:
=IFERROR(F3/MAX(G3:H3), "")
In K3:
=IF(I3="", "", I3-J3)
PierreK100
May 29, 2025Copper Contributor
HansVogelaar​ thank you very much