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!

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!

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!

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.

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