Forum Discussion
Chris_Van_Malsem
Jul 03, 2020Copper 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...
Riny_van_Eekelen
Jul 03, 2020Platinum Contributor
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
Jul 03, 2020Copper Contributor
Thank you Riny_van_Eekelen