| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining AND/OR in an IF statement
I have several columns that will contain either a "Y" or "N". I want to
check the columns to see if there is more than one "Y". How can I do this? Is it possible to combine AND with OR in an IF statement, and how is it done? C1 = Y C2 = N C3 = N C4 = Y C5 = Y C6 = N In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in these columns. Thanks for the help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining AND/OR in an IF statement
=COUNTIF(C1:C6,"Y")
Try the formula above in C7 "dread" wrote: I have several columns that will contain either a "Y" or "N". I want to check the columns to see if there is more than one "Y". How can I do this? Is it possible to combine AND with OR in an IF statement, and how is it done? C1 = Y C2 = N C3 = N C4 = Y C5 = Y C6 = N In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in these columns. Thanks for the help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining AND/OR in an IF statement
Wow that was too easy! Thank you very much!!!
"tim m" wrote: =COUNTIF(C1:C6,"Y") Try the formula above in C7 "dread" wrote: I have several columns that will contain either a "Y" or "N". I want to check the columns to see if there is more than one "Y". How can I do this? Is it possible to combine AND with OR in an IF statement, and how is it done? C1 = Y C2 = N C3 = N C4 = Y C5 = Y C6 = N In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in these columns. Thanks for the help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining AND/OR in an IF statement
dread
What about =COUNTIF(C1:C6,"=Y") Dave "dread" wrote in message ... I have several columns that will contain either a "Y" or "N". I want to check the columns to see if there is more than one "Y". How can I do this? Is it possible to combine AND with OR in an IF statement, and how is it done? C1 = Y C2 = N C3 = N C4 = Y C5 = Y C6 = N In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in these columns. Thanks for the help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining AND/OR in an IF statement
Just to explain that function if looks at C1 to C6 and if there is a Y it
counts the number of Y's. Further to your 1st question yes you can do ORs and ANDs with IF's if you have to. (In this instance the COUNTIF function works best though) "dread" wrote: Wow that was too easy! Thank you very much!!! "tim m" wrote: =COUNTIF(C1:C6,"Y") Try the formula above in C7 "dread" wrote: I have several columns that will contain either a "Y" or "N". I want to check the columns to see if there is more than one "Y". How can I do this? Is it possible to combine AND with OR in an IF statement, and how is it done? C1 = Y C2 = N C3 = N C4 = Y C5 = Y C6 = N In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in these columns. Thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Nested IF statement with Between operator | Excel Worksheet Functions | |||
| Combining an If Statement with NETWORKDAYS function | Excel Discussion (Misc queries) | |||
| Combining a Vlook up with and If then statement | Excel Worksheet Functions | |||
| combining an if statement | Excel Worksheet Functions | |||
| Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) | |||
Linear Mode
