Forum Discussion

Chris_Van_Malsem's avatar
Chris_Van_Malsem
Copper Contributor
Jul 03, 2020

Bulk fuel recording

Hi all, I am setting up a spreadsheet to monitor the fuel storage/usage for a transport company. If no amounts have been entered into the spreadsheet (i.e small tank, big tank etc.), I would like to...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 03, 2020

Chris_Van_Malsem The formula could be:

=IF(E5<>0,E4-E5,0)

or

=(E4-E5)*--(E5<>0)

 if you like it to be a bit more "funky".

  • Chris_Van_Malsem's avatar
    Chris_Van_Malsem
    Copper Contributor
    Jul 03, 2020

    Riny_van_Eekelen Sorry to be a pain, but if I was to add an amount in the delivery column that then was included in the total, how can I change the formula to take that delivery amount out of the calculation for the amount used? I hope that I've explained that well enough.

     

     

     

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jul 03, 2020

      Chris_Van_Malsem 

      Assuming you fill in the delivered quantity (in G) as a positive number, the formula would be like this:

      =IF(E5<>0,E4-E5+G5,0)

       Please see the attached example, replicating your worksheet.

Resources