Multiple Nested IFs, ORs, Ands
 

I've been playing with nested IFs, ORs, and Ands, with no luck. There may be
an easier way to do what I want, but I'm trying to accomplish the following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10 = y)
Then insert Yes into cell B1

Any help is apprecaited. THANKS

Multiple Nested IFs, ORs, Ands
 

Try:
=IF(OR(AND(B42="x",B8="y"),AND(B43="x",B9="y"),AND (B44="x",B10="y")),"Yes","")

Scott

Shelly wrote:
I've been playing with nested IFs, ORs, and Ands, with no luck. There may be
an easier way to do what I want, but I'm trying to accomplish the following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10 = y)
Then insert Yes into cell B1

Any help is apprecaited. THANKS

Multiple Nested IFs, ORs, Ands
 

=IF(OR(AND(B42=x,B8=y),AND(B43=x,B9=y),AND(B44=x,B 10=y)),"Yes","")
--
David Biddulph

"Shelly" wrote in message
...
I've been playing with nested IFs, ORs, and Ands, with no luck. There may
be
an easier way to do what I want, but I'm trying to accomplish the
following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10
= y)
Then insert Yes into cell B1

Any help is apprecaited. THANKS

Multiple Nested IFs, ORs, Ands
 

Try this, in cell B1 enter:

=IF(OR(AND(B42="x",B8="y"),AND(B43="x",B9="y"),AND (B44="x",B10="y")),"Yes","No")

HTH,
Elkar


"Shelly" wrote:

I've been playing with nested IFs, ORs, and Ands, with no luck. There may be
an easier way to do what I want, but I'm trying to accomplish the following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10 = y)
Then insert Yes into cell B1

Any help is apprecaited. THANKS

Multiple Nested IFs, ORs, Ands
 

EXCELLENT! Thank you!

"Scott" wrote:

Try:
=IF(OR(AND(B42="x",B8="y"),AND(B43="x",B9="y"),AND (B44="x",B10="y")),"Yes","")

Scott

Shelly wrote:
I've been playing with nested IFs, ORs, and Ands, with no luck. There may be
an easier way to do what I want, but I'm trying to accomplish the following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10 = y)
Then insert Yes into cell B1

Any help is apprecaited. THANKS

Multiple Nested IFs, ORs, Ands
 

Shelly wrote...
I've been playing with nested IFs, ORs, and Ands, with no luck. There may be
an easier way to do what I want, but I'm trying to accomplish the following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10 = y)
Then insert Yes into cell B1
....

An alternative,

=IF(SUMPRODUCT((B42:B44=x)*(B8:B10=y)),"Yes","")