Or

=IF(ISBLANK(A3),"",IF(A3=0.99,5,IF(A3=0.97,4,IF( A3=0.95,3,IF(A3=0.93,2,IF(A3<=0.92,1))))))

Peter


"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