Need help with a Formula ???

[RiceEatingZR1]

Hello all,

Sorry but I haven't been working with excel long I know that I can use
the IF function and was wondering if anyone can help me out. Here is
what I am trying to do:

I want to place a 1 in the WIN column (X) if column H or column L or
column P is " Standard Plus" and Column I J K M N O Q R S contain a "Y"



Thanks

Shaun

 

[Max]

Try in X2:

=IF(AND(I2="Y",J2="Y",K2="Y",M2="Y",N2="Y",O2="Y",Q2="Y",R2="Y",S2="Y",
OR(H2="Standard Plus",L2="Standard Plus",P2="Standard Plus")),1,"")

 

[RiceEatingZR1]

Thanks for the reply

 

[Max]

You're welcome !