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!
|