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 |
Can I apply a "score" based on multiple cell values?
Use tables, such as
M N 1 Score Pts 2 0 5 3 50.01 1 4 etc and use a formula of =VLOOKUP(the_score,M1:N10,2) and other similar formulae -- HTH RP (remove nothere from the email address if mailing direct) "Alynn" wrote in message ... 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 |
All times are GMT +1. The time now is 04:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com