NESTED OR FORMULAS
 

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

NESTED OR FORMULAS
 

details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"William" wrote in message
...
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.
--
William

NESTED OR FORMULAS
 

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

"William" wrote:

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

NESTED OR FORMULAS
 

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

--
HTH...

Jim Thomlinson


"William" wrote:

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

NESTED OR FORMULAS
 

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.
--
David Biddulph

"Mike H" wrote in message
...
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

"William" wrote:

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

NESTED OR FORMULAS
 

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


"Jim Thomlinson" wrote:

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

--
HTH...

Jim Thomlinson


"William" wrote:

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

NESTED OR FORMULAS
 

David,

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

Mike

"David Biddulph" wrote:

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.
--
David Biddulph

"Mike H" wrote in message
...
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

"William" wrote:

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