I have an assignment due very soon. Please HELP!
B Bob Phillips Oct 5, 2006 #2 Has to be in another cell =IF(A1=0,NA(),A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
Has to be in another cell =IF(A1=0,NA(),A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
T Teethless mama Oct 5, 2006 #3 What happen if A1>0 ? =IF(A1=0,"n/a",IF(A1<0,A1,"else another value"))
