Forum Discussion
IFS formula
=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.
1 Reply
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
