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 do a nested IF function. Could a OR function help? 

 

Thanks in advance!

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

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    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")

Resources