| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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","") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple ifs, and ands, and are not working | Excel Discussion (Misc queries) | |||
| Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
| work with multiple workbooks on separate monitor for 2003 edition | Excel Worksheet Functions | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
