View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
StumpedAgain StumpedAgain is offline
external usenet poster
 
Posts: 192
Default 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???