Forum Discussion
AND/OR Function
I am trying to write the formula, to where one two cells must meet three different range criteria to come back "yes" or "no". I need the cells to look something like this (I got it, its a hot mes...
Hi Walter,
Perhaps something like
=IF(
OR(
AND(B5>=90, A5<7),
AND(B5<90, B5>=80, A5<4),
AND(B5<80, B5>=70, A5<2)
), "yes", "no"
)
Sergei,
It works like a champ. You are awesome. Thank you for fixing this for me!