Multiple Nested IFs, ORs, Ands

Multiple Nested IFs, ORs, Ands

Post by U2hlbGx » Wed, 10 Jan 2007 09:39:00


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

Post by Scot » Wed, 10 Jan 2007 09:46:26

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

Scott

 
 
 

Multiple Nested IFs, ORs, Ands

Post by David Bidd » Wed, 10 Jan 2007 09:49:34

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

Multiple Nested IFs, ORs, Ands

Post by RWxrYX » Wed, 10 Jan 2007 09:52:00

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
 
 
 

Multiple Nested IFs, ORs, Ands

Post by U2hlbGx » Wed, 10 Jan 2007 10:07:00

EXCELLENT! Thank you!
 
 
 

Multiple Nested IFs, ORs, Ands

Post by Harlan Gro » Wed, 10 Jan 2007 10:07:45

Shelly wrote...
...

An alternative,

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