I have =IF(B1>50,2,1) in cell A1 How an a get a blank value if B1 is blank in A1
L lostinmacro Mar 18, 2008 #1 I have =IF(B1>50,2,1) in cell A1 How an a get a blank value if B1 is blank in A1
D Dave Peterson Mar 18, 2008 #2 =if(b1="","",if(b1>50,2,1)) I have =IF(B1>50,2,1) in cell A1 How an a get a blank value if B1 is blank in A1 Click to expand...
=if(b1="","",if(b1>50,2,1)) I have =IF(B1>50,2,1) in cell A1 How an a get a blank value if B1 is blank in A1 Click to expand...
