Here is my formula:
=ARRAYFORMULA(IF(S2:S>=90%,'Task Performance Legend'!C2,IF(AND(S2:S<90%,S2:S>=80%),'Task Performance Legend'!C3,IF(AND(S2:S<80%,S2:S>=70%),'Task Performance Legend'!C4,IF(AND(S2:S<70%,S2:S>=60%),'Task Performance Legend'!C5,IF(S2:S<60%,'Task Performance Legend'!C6))))))
What I am looking to do is display a message if the number falls within a range. I receive an error, "function divide parameter 2 cannot be zero" if the percentage doesn't equal 100%:
formula in action message legend
I'm stumped
Aucun commentaire:
Enregistrer un commentaire