View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott Scott is offline
external usenet poster
 
Posts: 87
Default 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