what is the symbol to use AND and OR and Inbetween or how to use it in this
scenario

"Jacob Skaria" wrote:

I would suggest to put this in order and use '<' sign or '' sign.

The problem here is suppose C54 = 125% .This satisfies the condition 90,
100, 110 and 120..and so excel picks the 1st condition.....Better put that
in an order and use either < or ....

Or use the AND operator to mention any special conditions..

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


"Jafferi" wrote:

Thank you very much; it helps - however, if I have more options, it does not
give me the desired results. what should I do?

=IF(C54<80%,"Good Job! Thank you for your focus",IF(C5490%,"Require
Coaching!",IF(C54100%,"Verbal Warning!!",IF(C5460%,"1st Letter of
Warning!!!",IF(C54110%,"2nd Letter of Warning!!!!",IF(C54120%,"!!!!!Final
Letter of Warning!!!!!"))))))

The results is 244.4%, and it shows as Require Coaching instead of Final
Letter of Warning




"Jacob Skaria" wrote:

=IF(A1<=2,"",IF(A1<5,"Monitor Performance",IF(A14,"Require Coaching!")))
--
If this post helps click Yes
---------------
Jacob Skaria


"Jafferi" wrote:

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?