Need help with a Formula ???

  • Thread starter Thread starter RiceEatingZR1
  • Start date Start date
R

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
 
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,"")
 
Back
Top