Alternate solution using LOOKUP
=LOOKUP(B12,{1,2,3,4,5,7},{"Keep it up","Good","Require Monitoring","Require
Coaching","Employee P-File and Close Coaching"," Immediate Action, P-File and
Coaching"})


If this post helps click Yes
---------------
Jacob Skaria


"Jafferi" wrote:

I have a list of grades that I need a formula to provide the results for
better immediate actions.
Results that shows:
If results is | Comment
1 Keep it up
2 Good
3 Require Monitoring
4 Require Coaching
5-6 Employee P-File and Close Coaching
above 6 Immediate Action, P-File and Coaching

I uses the following formula, but it does not work as it still shows as
Require monitoring no matter what the result is.

=IF(B12=3,"Require Monitoring",(IF(B12=4,"Require
Coaching",(IF(B12=5,"Employee P-File & Coaching",IF(B126,"Immediate
Action_P-File_Coaching","Require Monitoring"))))))