Forum Discussion

Whitney Johnson's avatar
Whitney Johnson
Copper Contributor
Oct 25, 2018
Solved

Excel If Functions

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 wa...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Oct 25, 2018

    Hi

     

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

     

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Oct 25, 2018
try:
assuming cell1 is A1 and cell2 is A2
=IF((A1+A2)>0,A1+A2,0)