Score Rating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alish - 08 Jan 2008 12:07 GMT

All, I would appreciate if you could helpme with the following:
I am trying to determine the score level in one cell for the belo creteria:

score rate

>80 or <90 "need improvement"
>90 or <95 "good"
>95 or =100 "excellent"

I will have two cells where in one I will input the score and the second one
determines the rate of the score. Thanks.

Reply to this Message

Gary''s Student - 08 Jan 2008 12:33 GMT

=IF(A1>95,"excellent",IF(A1>90,"good","needs improvement"))

Signature

Gary''s Student - gsnu200764

Reply to this Message

alish - 08 Jan 2008 13:05 GMT

Thanks! It worked!

> =IF(A1>95,"excellent",IF(A1>90,"good","needs improvement"))

Reply to this Message