formula problem
Posted by Mike Farrow on November 23, 2001 8:55 AM
I have put in a formula of =IF(B1=D2,1,"") but I don't want anything in the cell if there is no numbered text in cell B1 or D2. How can I solve this?
Posted by JJ on November 23, 2001 9:18 AM
Hi there, the following should solve the problem:
=IF(OR(B1="",D1=""),"",IF(B1=D1,1,""))
N.B. if you are copying it down remember to fix the cells B1 and D1!
Posted by Bib on November 23, 2001 9:21 AM
Try =IF(B1<>"";IF(D2<>"";IF(B1=D2;1;0);"");"")
Cheers
