A - 5
=IF(A<=2,"",IF(a3,"Monitor Performance",IF(a5,"Require Coaching!")))
How come the result I got in B is 'Monitoring Performance', is my formula
wrong?

It's not in the proper sequence. The first IF is FALSE so it moves to the
next IF. IF(a3, 5 is greater than 3 so the formula stops at that point and
returns Monitor Performance.

Try testing for the highest value first then work downwards.

=IF(A1=5,"Require Coaching!",IF(A1=3,"Monitor Performance",""))

Assuming the values in A are always whole numbers.

--
Biff
Microsoft Excel MVP


"Jafferi" wrote in message
...
I am trying to get a results for a score. for example in cell A, the cell
(which is the results) shows as 5; I need cell B to tell me that if the
value
in cell A is less than or equal to 2, leave cell blank, if the value in
cell
B is between 3 to 4 result MONITOR PERFORMANCE and if the result is equal
to
5 and above results to show REQUIRE COACHING

A - 5
B - =IF(A<=2,"",IF(a3,"Monitor Performance",IF(a5,"Require Coaching!")))

How come the result I got in B is 'Monitoring Performance', is my formula
wrong?