Can I apply a "score" based on multiple cell values?

[Guest]

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

 

[Bob Phillips]

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)