=IF(G81+J81=0,0,2) OK, I want to add another cell to this formula which will calculate that cell and return its value in cell X eg: =IF(G81+J81=0,0,2) if(I81=0,0,1)so in other words 2 cells will return 0 or 2 and the other cell return 0 or 1, how do I include the other cell ?
@R-Canzius - I am not exactly sure about the formula you would like to have thus only a bit of a vague answer.
Look into the AND formula and combine it with the IF -function. Most likely you will need to create a formula like =IF(AND…