Can I apply a "score" based on multiple cell values?
I have created a table in Excel that lists various measurements of office
performance. I'd like to apply points for each level of value.
eg. if the value is <20% the score = 5 points; if it's 50% the score = 1
point...etc.
Ideally I have several points to add together to determine each office's
overall "score".
Thanks,
Alynn
|