For quality feedback to employees, we use 3 classifications for performance:
Y (with a score from 1-5)
N (equals 0 score)
N/A (equals 0 score; this question’s 5 points are removed from total points available
My question is how to write the “IF” statement for the total available points.
Here’s what I have but it isn’t working for all of it:
C8 = Yes cell with score 1-5
D8 = No cell with score N
E8 = N/A cell with N/A as the value
Basically, if they performed well, they received a score of 1-5 out of the “total points” of 5 for the question. If they failed the task, they get a score of “N” out of a “total points” of 5 for the question. If the task was not applicable, N/A is scored out of a “total points” of 0 for the question.
Any assistance is greatly appreciated.