IFS formula

[cellison01]

=IFS(B5>=90,"HP",B5>=70"P",B5>=50,"PP",B5<=49,"MP",B5="na","")

I am trying to use the above formula.  I am running into a problem when the cell has "na".  The formula works great if there is a number in the cell, but I have to use "na" as a placeholder.  It returns a score when "na" is present, but I want it to be blank.

This person doesn't have a score for this test, yet is considered Highly Proficient.  I need this to be blank.

[#2]

@cellison01 Change the formula to:

=IFS(B3="na","",B3>=0.9,"HP",B3>=0.7,"P",B3>=0.5,"PP",B3<=0.49,"MP")

First test for "na", then for the values, noting that 90% = 0.9 not 90, etc