Hi guys,
I am working on an evaluation sheet in excel 2010. Which looks as following:
Criteria Weighfactor Score (A/B/C/D) Weighted score
1.Housekeeping 40% A ...
2.QHSE 20%
3. ...
4. ...
5. ...
6. ...
7. ...
8. ...
Every criteria has a weight factor which is a number. The rating that the evaluator is giving the criteria is a letter grade.
I do have the formula to calculate the average of all letters which is
=CHAR(INT(SUM(IF(E25:E78<>"",CODE(E25:E78))/COUNTA(E25:E78))))
Does anybody have an idea how to implement the weight factor (for example 40%) to the letter grade so at the end at the right average is calculated.
Thanks for your help,
Nico
Bookmarks