NESTED OR FORMULAS

W

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.
 
M

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
 
J

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...
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top