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.