Forum Discussion

Hayley_W's avatar
Hayley_W
Copper Contributor
Jan 19, 2024

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

  • Hayley_W 

    In Column3:

    =IF(OR([@[Planned Tonnage]]="", [@[Produced Tonnage]]=""), "", [@]Produced Tonnage]]-[@[Planned Tonnage]])

Resources