NESTED OR FORMULAS

[William]

Is it possible to string together nested OR formulas in a similar way to
nested IFs? I keep trying to bring this off by modeling the OR nesting after
IF nesting, but Excel is telling me I'm entering too many arguments.

 

[Don Guillett]

details?

 

[Mike H]

Hi,

Yes it is an here's an example but if you post what you are trying to do
then I'm sure someone could be of more help.

=OR(A1=1,OR(22/6=PI(),A3=9),A4=11)

And yes I'm aware the 22/6 will always evaluate as false, the point is if
any of A1 or A4 (or both) are true formula evaluates as true and if A3 is
true it evaluates as True

Mike

 

[Jim Thomlinson]

Not too sure what you are asking. Here is an example of nested boolean...

=or(or(a1=1, b1=2, c1=3), and(d1<>"", e1<>""))

The above function will return true or false depending on
if (a1=1 or b1=2 or c1=3) then it will return true
or
if d1<>"" and e1<>"" then it will return true

Not sure if that helps or not...

 

[David Biddulph]

And, of course, you don't need the extra OR.

=OR(A1=1,OR(22/6=PI(),A3=9),A4=11)
will be the same as
=OR(A1=1,22/6=PI(),A3=9,A4=11)
because if any one of the 4 conditions is satisfied, the result is true.

 

[William]

Thanks, everyone. I'm going to repost with an example.

 

[Mike H]

David,

I knew that but it made the example more intuative for the OP

Mike