Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IN operator
I'm writting a nested if statement, referencing 3 cells. My condition is that
if any one of the 3 cells have a value < Y or < N/A, the resulting value should be "N". If tried and(or( and every combination there of. Sql has an IN operator but i don't believe Excel does. Any suggestions? Here's where i'm at: =IF(OR(P7<"Y",Q7<"Y",R7<"Y",P7<"N/A",Q7<"N/A",R7<"N/A"),"N","Y") I'm looking to check if there's a value other than Y or N/A in ANY of the 3 cells. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IN operator
maybe
=IF(COUNTIF(P7:R7,"Y")+COUNTIF(P7:R7,"N/A")<3,"N","Y") "Suzanne" wrote: I'm writting a nested if statement, referencing 3 cells. My condition is that if any one of the 3 cells have a value < Y or < N/A, the resulting value should be "N". If tried and(or( and every combination there of. Sql has an IN operator but i don't believe Excel does. Any suggestions? Here's where i'm at: =IF(OR(P7<"Y",Q7<"Y",R7<"Y",P7<"N/A",Q7<"N/A",R7<"N/A"),"N","Y") I'm looking to check if there's a value other than Y or N/A in ANY of the 3 cells. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IN operator
Wonderful! Thanks Duke.
"Duke Carey" wrote: maybe =IF(COUNTIF(P7:R7,"Y")+COUNTIF(P7:R7,"N/A")<3,"N","Y") "Suzanne" wrote: I'm writting a nested if statement, referencing 3 cells. My condition is that if any one of the 3 cells have a value < Y or < N/A, the resulting value should be "N". If tried and(or( and every combination there of. Sql has an IN operator but i don't believe Excel does. Any suggestions? Here's where i'm at: =IF(OR(P7<"Y",Q7<"Y",R7<"Y",P7<"N/A",Q7<"N/A",R7<"N/A"),"N","Y") I'm looking to check if there's a value other than Y or N/A in ANY of the 3 cells. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IN operator
Try this:
=IF(OR(P7:R7="Y",P7:R7="N/A"),"Y","N") This is an array formula and will need to be entered using cntrl + shift + enter. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IN operator
Thank you! I'll give it a try.
"Brian Taylor" wrote: Try this: =IF(OR(P7:R7="Y",P7:R7="N/A"),"Y","N") This is an array formula and will need to be entered using cntrl + shift + enter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Concatenate operator to overcome 7 nested IF's | Excel Worksheet Functions | |||
add one cell with no equals operator | Excel Discussion (Misc queries) | |||
corrupt program or file? How to tell? Or is it operator error? | Excel Discussion (Misc queries) | |||
SaveAS to a specific folder, with operator input of file name | Excel Discussion (Misc queries) | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions |