Hi All

I am very new to the forum but looking to learn how to take advantage of some of the power of excel. I am getting ready to start my annual reviews. A sheet that would allow me to show the ratings would be very helpful. There is a measurement range that I want to translate the rating in another column.

I am not sure if/then or conditional formatting or a combination can do what I want.

This is what I want to do, however, I am not sure how to write it.

=IF(A2=<95%, B2, "1- Unsatisfactory Results")
=IF(A2=between 95% and 99.99%, B2, "2 - Met Most Results")
=IF(A2=between 100% and 104.99%, B2, "3 - Successful Results")
=IF(A2=between 105% and 109.99%, B2, "4 - Superior Results")
=IF(A2=greater than or equal to 110%, B2, "5 - Exceptional Results")

Any help would be greatly appreciated.