| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| multiple functions | Excel Worksheet Functions | |||
| Multiple if functions with sum | Excel Worksheet Functions | |||
| Multiple Functions | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
![Jafferi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
