The following does not seem to work: =IF(A1>0 & B1<>"",A1,"") Is this syntax incorrect?
P PE Apr 19, 2007 #1 The following does not seem to work: =IF(A1>0 & B1<>"",A1,"") Is this syntax incorrect?
P Pete_UK Apr 19, 2007 #2 I think this is what you are trying to do: =IF(AND(A1>0,B1<>""),A1,"") Hope this helps. Pete
