Forum Discussion

PierreK100's avatar
PierreK100
Copper Contributor
May 28, 2025
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....
  • HansVogelaar's avatar
    May 28, 2025

    In I3:

    =IFERROR(F3/MAX(G3:H3), "")

    In K3:

    =IF(I3="", "", I3-J3)

Resources