View Full Version : [SOLVED:] Can This Expression Be Simplified?
Cyberdude
04-17-2005, 09:01 PM
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
04-17-2005, 09:22 PM
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
04-17-2005, 09:37 PM
Or for a non array approach:
=If(Countif(A1:A15,TRUE), TRUE PART HERE, FALSE PART HERE)
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
04-18-2005, 09:05 AM
You will get an error with that formula if there are no TRUE values in the range.
Cyberdude
04-18-2005, 09:06 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.