IF OR Statement

[Patchcord]

I'm looking to write a formula to satisfy two possible states:

=IF(OR(ISTEXT(C9,D9))

I need the formula to report a TRUE condition if text is present in either C9 or D9, but I keep getting an error. Does anyone have any thoughts?

 

[Aladin Akyurek]

I'm looking to write a formula to satisfy two possible states:

=IF(OR(ISTEXT(C9,D9))

I need the formula to report a TRUE condition if text is present in either C9 or D9, but I keep getting an error. Does anyone have any thoughts?

Either:

=OR(ISTEXT(C9),ISTEXT(D9))

Or:

=COUNTIF(C9:D9,"?*") > 1

The latter would ignore "".

 

[Patchcord]

That's great. Thanks for your help!

 

[Peter_SSs]

Or:

=COUNTIF(C9:D9,"?*") > 1

The latter would ignore "".

This gives FALSE for me with "" in C9 and "text" in D9 - see B9 below.

Shouldn't it be
=COUNTIF(C9:D9,"?*") > 0 - see B10 below?

Mr Excel.xls
	A	B	C	D	E
8
9		FALSE		text
10		TRUE
11
Check for Text

 

[Aladin Akyurek]

Or:

=COUNTIF(C9:D9,"?*") > 1

The latter would ignore "".

This gives FALSE for me with "" in C9 and "text" in D9 - see B9 below.
...

Yes, it should: either >=1 or just >0, but I don't see the need for an exhibit to point that out.