Multiple Nested IFs, ORs, Ands

S

Shelly

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
 
S

Scott

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

Scott
 
E

Elkar

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
 
H

Harlan Grove

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
Click to expand...
....

An alternative,

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

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

Similar Threads

Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible? 10
nested IF AND too cumbersome 4
VLOOKUP help needed! 1
Avoiding nested if statements? 14
Special Paste to Next empty row if new data and mark copied Macro 0
help needed with lookup and related functions 3
Referring to multiple worksheets via a variable 2
Multiple-level category labels 0

Top