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