J
Jafferi
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(B12>6,"Immediate
Action_P-File_Coaching","Require Monitoring"))))))
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(B12>6,"Immediate
Action_P-File_Coaching","Require Monitoring"))))))