| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
Is it possible to put multiple IF functions to one cell? For examples, say I
want to assign different descriptions depending on what value shows up in a cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
You can use something like this if you have a "few" conditions:
=IF(A1=90,"Excellent",IF(A1=80,"Good",IF(A1=70, "Average","Need Improvement"))) If you have more than a "few" conditions then your best approach is to create a 2 column lookup table. Post back if that might be the case. -- Biff Microsoft Excel MVP "JP" wrote in message ... Is it possible to put multiple IF functions to one cell? For examples, say I want to assign different descriptions depending on what value shows up in a cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Yes, I need about 8 functions....I tried the equation below and it excepted
the formula, but it wouldn't change the answer for each variable, it just posted the first. "T. Valko" wrote: You can use something like this if you have a "few" conditions: =IF(A1=90,"Excellent",IF(A1=80,"Good",IF(A1=70, "Average","Need Improvement"))) If you have more than a "few" conditions then your best approach is to create a 2 column lookup table. Post back if that might be the case. -- Biff Microsoft Excel MVP "JP" wrote in message ... Is it possible to put multiple IF functions to one cell? For examples, say I want to assign different descriptions depending on what value shows up in a cell. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Another factor is a range...per your example:
=IF(95<A190,"Good",IF(90<A185,"Okay")) Total of 7..... Now knowing all the details, can this be done? "JP" wrote: Yes, I need about 8 functions....I tried the equation below and it excepted the formula, but it wouldn't change the answer for each variable, it just posted the first. "T. Valko" wrote: You can use something like this if you have a "few" conditions: =IF(A1=90,"Excellent",IF(A1=80,"Good",IF(A1=70, "Average","Need Improvement"))) If you have more than a "few" conditions then your best approach is to create a 2 column lookup table. Post back if that might be the case. -- Biff Microsoft Excel MVP "JP" wrote in message ... Is it possible to put multiple IF functions to one cell? For examples, say I want to assign different descriptions depending on what value shows up in a cell. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Create a 2 column table like this:
...........F..........G..... 1........0..........Poor 2........40........Below Average 3........50........Average 4........60........Above Average 5........70........Good 6........80........Very Good 7........90........Outstanding A1 = some number =IF(A1="","",VLOOKUP(A1,F1:G7,2)) 0 - 39 = Poor 40 - 49 = Below Average 50 - 59 = Average 60 - 69 = Above Average 70 - 79 = Good 80 - 89 = Very Good 90+ = Outstanding -- Biff Microsoft Excel MVP "JP" wrote in message ... Another factor is a range...per your example: =IF(95<A190,"Good",IF(90<A185,"Okay")) Total of 7..... Now knowing all the details, can this be done? "JP" wrote: Yes, I need about 8 functions....I tried the equation below and it excepted the formula, but it wouldn't change the answer for each variable, it just posted the first. "T. Valko" wrote: You can use something like this if you have a "few" conditions: =IF(A1=90,"Excellent",IF(A1=80,"Good",IF(A1=70, "Average","Need Improvement"))) If you have more than a "few" conditions then your best approach is to create a 2 column lookup table. Post back if that might be the case. -- Biff Microsoft Excel MVP "JP" wrote in message ... Is it possible to put multiple IF functions to one cell? For examples, say I want to assign different descriptions depending on what value shows up in a cell. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function
Where do I create the table? On a seperate sheet?
"T. Valko" wrote: Create a 2 column table like this: ...........F..........G..... 1........0..........Poor 2........40........Below Average 3........50........Average 4........60........Above Average 5........70........Good 6........80........Very Good 7........90........Outstanding A1 = some number =IF(A1="","",VLOOKUP(A1,F1:G7,2)) 0 - 39 = Poor 40 - 49 = Below Average 50 - 59 = Average 60 - 69 = Above Average 70 - 79 = Good 80 - 89 = Very Good 90+ = Outstanding -- Biff Microsoft Excel MVP "JP" wrote in message ... Another factor is a range...per your example: =IF(95<A190,"Good",IF(90<A185,"Okay")) Total of 7..... Now knowing all the details, can this be done? "JP" wrote: Yes, I need about 8 functions....I tried the equation below and it excepted the formula, but it wouldn't change the answer for each variable, it just posted the first. "T. Valko" wrote: You can use something like this if you have a "few" conditions: =IF(A1=90,"Excellent",IF(A1=80,"Good",IF(A1=70, "Average","Need Improvement"))) If you have more than a "few" conditions then your best approach is to create a 2 column lookup table. Post back if that might be the case. -- Biff Microsoft Excel MVP "JP" wrote in message ... Is it possible to put multiple IF functions to one cell? For examples, say I want to assign different descriptions depending on what value shows up in a cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
