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 kn...
HansVogelaar
Jan 19, 2024MVP
In Column3:
=IF(OR([@[Planned Tonnage]]="", [@[Produced Tonnage]]=""), "", [@]Produced Tonnage]]-[@[Planned Tonnage]])