I am trying to create an IF statement, but it is not working. I need it to say if cell1 and cell2 are NA the true is 0 but if it is >0 to = the sum of cell1 and cell2. I have tried so many ways, but I can never get the 0 result, but if there are #'s in the cells it will return the sum of those 2 cells.

Forum Discussion

Copper Contributor

Oct 26, 2018

Solved

I am trying to create an IF statement, but it is not working.

I need it to say if cell1 and cell2 are NA the true is 0 but if it is >0 to = the sum of cell1 and cell2.

I have tried so many ways, but I can never get the 0 result, but if there are #'s in the cells it will return the sum of those 2 cells.