Multiple IF functions

[Jafferi]

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(a>3,"Monitor Performance",IF(a>5,"Require Coaching!")))

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

 

[Jacob Skaria]

=IF(A1<=2,"",IF(A1<5,"Monitor Performance",IF(A1>4,"Require Coaching!")))

 

[Jafferi]

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(C54>90%,"Require
Coaching!",IF(C54>100%,"Verbal Warning!!",IF(C54>60%,"1st Letter of
Warning!!!",IF(C54>110%,"2nd Letter of Warning!!!!",IF(C54>120%,"!!!!!Final
Letter of Warning!!!!!"))))))

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

 

[AnimalMagic]

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(C54>90%,"Require
Coaching!",IF(C54>100%,"Verbal Warning!!",IF(C54>60%,"1st Letter of
Warning!!!",IF(C54>110%,"2nd Letter of Warning!!!!",IF(C54>120%,"!!!!!Final
Letter of Warning!!!!!"))))))

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

I think you can only nest 7 IF levels.

 

[Jacob Skaria]

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

 

[T. Valko]

A - 5

=IF(A<=2,"",IF(a>3,"Monitor Performance",IF(a>5,"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(a>3, 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.

 

[Jafferi]

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