=LOOKUP(A10,{0,1;0.96,2;0.98,3;0.997,4})

--
HTH

Bob Phillips

"mimmson" wrote in
message ...

I'm trying to create a formula for the following.

A numerical score of between 1 and 4 is given, for anyone whose
accuracy score falls in the percentiles below.


ACCURACY

100- 99.7% = 4

99.6 - 98% = 3

97.9 - 96% = 2

95.9% and below = 1


What I would like to do is enter the percentage of accuracy in one cell
and have it automatically calculate the score (1-4) to another.

Any help would be greatly appreciated.

Thanks!


--
mimmson
------------------------------------------------------------------------
mimmson's Profile:
http://www.excelforum.com/member.php...o&userid=23809
View this thread: http://www.excelforum.com/showthread...hreadid=374637