dimanche 14 mars 2021

Google sheets array formula display a message if the number falls within a range

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