Greetings
I have a set of data that I need to calculate in Excel and come up with one specific answer.
An example of the data is:
Monthly Hr Quotient Effective Hr Quotient Exceptional Hr Quotient Score 0-10 MR Performance Analysis
97.30 2062.50 3281.25
4291.33 2062.50 3281.25
2805.91 2062.50 3281.25
823.30 2062.50 3281.25
I need to determine if their score per row is 0, 5, 10.
The logic for the decision is
Number Feedback
10 Exceptional
5 Effective
0 Ineffective
#N/A
#N/A #N/A
I tried using nested IF statements: =IF(A2<B2,"0",IF(A2>C2,"10",IF(A2>A2,IF(F2<C2,"5","NA"))))
Which worked fine for the results of 0 and 10 but the mid-range result is #NAME?
Any suggestions on how to resolve that problem?
Your cooperation and time is much appreciated…
Kevin
Bookmarks