Multiple IF functions
 

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?

Multiple IF functions
 

=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?

Multiple IF functions
 

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?

Multiple IF functions
 

On Tue, 7 Apr 2009 21:32:01 -0700, 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


I think you can only nest 7 IF levels.

Multiple IF functions
 

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?

Multiple IF functions
 

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?

Multiple IF functions
 

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?