Forum Discussion

daniel wong's avatar
daniel wong
Copper Contributor
Oct 16, 2017
Solved

IF conditions

I would like for cell T2 to be able to give a YES output should cell N2 be < or = 1900 or cell P2 be < or = 650. NO if the numbers do not meet the condition.   Screenshot attached   Was unable to...
Formulas & Functions
Need Help
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Oct 16, 2017

    Daniel,

     

    you are already doing the individual checks in R2:S2.

    So you could refer to these cells:

    =IF(COUNTIFS(R2:S2,"YES"),"YES","NO")
vakash6284's avatar
vakash6284
Copper Contributor
Oct 16, 2017

Hi Daniel,

 

Good Morning

 

This is the solution of your query.

IF(OR($I88<=1900,K88<=650),"YES","NO")

I think you don't need column R and S.

Please let me know if you need anything else.

 

Thanks & Regards

Akash Saxena

Resources