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...
  • Detlef_Lewin's avatar
    Oct 25, 2018

    Hi

     

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