If formula

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steve D (daronco02_at_yahoo.com)
Date: 05/07/04 

Date: Fri, 7 May 2004 11:42:20 -0700

=IF(B4=1,(IF(C4=1,"Y","N")),"N")
This formula is basically saying if b4 =1 AND c4 =1, code
as a yes. If neither condition is met, code as a no
What I need to change is from it counting if a cell has
a "1" in it, to it counting if there's any text in it.
For example:

If b4 =text AND c4 =text, code as a yes. If neither
condition is met, code as a no.

Does anyone out there have any tips for me...please email
to

Quantcast