Create a table with your range of values, something like the following:

A B
0 1
..93 2
..95 3
..97 4
..99 5

And then find the VLOOKUP function in help and reference the lookup table
above to return your value.
--
Kevin Backmann
"ExcelDummy" wrote:

I'm trying to create a formula example 99% and above is rated a 5 97%-98%
would be rated a 4 95%-96% would be rated a 3 and 93%-94% would be rated a 2
and 92% and below would be rated a 1 . So in example cell one would have a
score of 96% and cell 2 would show the rating of 3. I hope this makes sense.
--
Thank you
ExcelDummy