Forum Discussion
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...
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")
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")
- Thank for helping Detlef
