Forum Discussion
Solved
Scorecard
I am trying to mimic a formula that my company uses for year end evaluation
Each question has score of 1 to 5 .First section of questions is worth 50% and other two 25% each .
The final score is out of 5 total .
I am not sure if it's something that can he build in excel .
Each question has score of 1 to 5 .First section of questions is worth 50% and other two 25% each .
The final score is out of 5 total .
I am not sure if it's something that can he build in excel .
Based upon your tables, either SUM or AVERAGE could be used.
= SUM(job)/6 + SUM(team,leadership)/16 = (AVERAGE(job) + AVERAGE(team,leadership)) / 2The weights (numbers shown in cyan) will change it the number of questions in a section changes.
3 Replies
Here is an example with possible changes that can be made by the user.
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
NikolinoDE This is what i am trying to build the final score should be out of 5 points total
Based upon your tables, either SUM or AVERAGE could be used.
= SUM(job)/6 + SUM(team,leadership)/16 = (AVERAGE(job) + AVERAGE(team,leadership)) / 2The weights (numbers shown in cyan) will change it the number of questions in a section changes.
