Can This Expression Be Simplified?

[Cyberdude]

The expression has the general format:

OR(A1=TRUE,A2=TRUE,...,A15=TRUE)
I've tried omitting the "=TRUE", but it works only if one of the items is TRUE. If all are FALSE, then I get a error. I would really like to simplify the expression if I can. Any ideas? :banghead:

[Ken Puls]

Hi Sid,

Try this:


=or(A1:A15=True)

Enter it as an array formula though. (Press CTRL+SHFT+Enter)

It should show up as {=or(A1:A15=True)}

Should do what you need, returning False if all are false, not an error.

HTH,

[Jacob Hilderbrand]

Or for a non array approach:


=If(Countif(A1:A15,TRUE), TRUE PART HERE, FALSE PART HERE)

[acw]

Hi


=or(a1:a15).

If one of the entries is true, then it should equate to true. If none is true, then it will equate to false.


Tony

[Jacob Hilderbrand]

You will get an error with that formula if there are no TRUE values in the range.

[Cyberdude]

Guys, this is very embarrassing, but my original sequence:
OR(A1,A2, ... , A15)
does indeed work as it should. I made a coding error elsewhere, and that error gave me faulty results.
HOWEVER, I found ALL your suggestions very informative and instructive, and I appreciate them.
Cyberdude