Forum Discussion
Whitney Johnson
Oct 25, 2018Copper Contributor
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...
- Oct 25, 2018
Hi
=IFNA(SUM(A1:A2),0)
Detlef_Lewin
Oct 25, 2018Silver Contributor
Hi
=IFNA(SUM(A1:A2),0)
- Whitney JohnsonOct 26, 2018Copper ContributorThank you! This worked!