Forum Discussion
Hayley_W
Jan 19, 2024Copper Contributor
how to set up a loss column in excel
Hello,
Please can you let me know how to set up a +/- column for the difference between the data in columns as below
I want the different to be automatically be calculated in the 3rd column
I know there is an easy formula for this but i cant find it online.
Help appreciated.
thanks
1 Reply
In Column3:
=IF(OR([@[Planned Tonnage]]="", [@[Produced Tonnage]]=""), "", [@]Produced Tonnage]]-[@[Planned Tonnage]])