Not sure if this has been discussed before, if it has, appreciate if you can point me to it, but i have been trying to calculate between 2 columns and within a column itself.
Afterwhich, I need the answer to auto populate a following table, something like a summary table.
For eg - The Daily consumption of Fuel Oil on Apr 1 will auto generate at the Daily Consumption Table once the log from the vessel is recorded on Apr 2 morning on the R.O.B table. Also a top-up of Fuel once once a week will need to be taken into account.
I’ve attached a diagram . Using Xcel it will be the If logic formula… Thanks in advance.