Ignoring Cells through IF Functions
should work:
=IF(A2="","",IF(A1<0,A1,"") & IF(A2<0,A2,""))
"Hamed parhizkar" wrote:
In cell A1 i have 200, in cell A2 I have 250
In cell A3 I have an if function =if(a1<0,A1,"")&if(A2<0,A2,"")
My question is, can I make a formula to say that if A2 is 0 then it would
ignore cell A1... So if A2 is blank, then my output would be blank???
|