Excel If Functions

[Whitney Johnson]

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.

[#2]

try:
assuming cell1 is A1 and cell2 is A2
=IF((A1+A2)>0,A1+A2,0)

[#3 · Accepted solution]

Hi

=IFNA(SUM(A1:A2),0)

[#4]

Thank you! This worked!