If formula

  • Thread starter Thread starter Steve D
  • Start date Start date
S

Steve D

=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
 
Try

=IF(COUNTA(B4:C4)=2,"Yes","No")

you can also lookup the AND operator as it can come in handy for such
things.
 
=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
Click to expand...

I'm not sure from your wording whether you want an AND or an OR.

If you want a YES only if BOTH b4 and c4 are text, then:

=IF(AND(ISTEXT(B4),ISTEXT(C4)),"YES","NO")

If you want a YES if EITHER b4 or c4 is text, then:

=IF(OR(ISTEXT(B4),ISTEXT(C4)),"YES","NO")


--ron
 
Should he use your formulas, I'll let him know that they only count TEXT,
and will not count 1 unless it's entered as '1 ...
 
Hi Steve
You could also use the quick and dirty way to say "isn't blank"

B4<>"

So your formula could be

=IF(AND(B4<>"",C4<>""),"Y","N"

or one more way would be to say if either is blank then no

=IF(OR(B4="",C4=""),"N","Y"

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Steve D wrote: ----

=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 n
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
 
Should he use your formulas, I'll let him know that they only count TEXT,
and will not count 1 unless it's entered as '1 ...
Click to expand...

You are correct, of course.

I interpreted his request as asking specifically for TEXT.


--ron
 
Back
Top