Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Cell Values, please help | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Returning Multiple Values Based on One Value | Excel Worksheet Functions | |||
How can I get excel to apply values in a cell before or after date | Excel Worksheet Functions | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |