could you clarify those boundaries?
but fyi you dont use and /or like you have
Formula:
=IF(AND(A1>=59),"HIGH",IF(OR(A1<=9),"LOW","MEDIUM"))
why the and/or
it should be
Formula:
=IF(A1>=59,"HIGH",IF(A1<=9,"LOW","MEDIUM"))
in your second one
Formula:
IF(AND(A1<12),"STRONG",AND(IF(OR(11<A1<35),”SATISFACTORY”)),IF(OR(34<A1<112),”NEEDS IMPROVEMENT”)),"WEAK")
you seem to be seeing if a1 is<12 then "strong" but the next test is a1>11 so what would happen if a11 was 12?
Formula:
=IF(A1<12,"STRONG",IF(A1<35,"SATISFACTORY",IF(A1<112,"NEEDS IMPROVEMENT","WEAK")))
might be it
but if you understand lookup go with that
Bookmarks