Highlighted
New Contributor

# 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 show the usage cell as zero, but cannot get the formula correct. I entered the formula =sum(E3-E4) to give me the usage, but that creates it's own problems where there a zero in the following cell.. All help is appreciated.

4 Replies
Highlighted

# Re: Bulk fuel recording

@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".

Highlighted

# Re: Bulk fuel recording

Thank you @Riny_van_Eekelen

Highlighted

# Re: Bulk fuel recording

@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.

Highlighted

# Re: Bulk fuel recording

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.