Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text IF
I want to use text as a logical in an IF formula which I am sure you must be
ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text IF
One way:
=IF(D19="sch","liz",IF(D19="TCh","lex",IF(D19="POS ","mav","other"))) However, you're limited to 7 levels of nesting pre-XL07. You may do better with a lookup. For instance: J K 1 sch liz 2 TCh lex 3 POS mav Then use the formula =VLOOKUP(D19,J:K,2,FALSE) or, if it's possible that D19 has a value not in the table: =IF(ISNA(VLOOKUP(D19,J:K,2,FALSE)),"other",VLOOKUP (D19,J:K,2,FALSE) In article , Be18 wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text IF
Thanks for your reply. My formula looks like the first one, as i only have
five, however when i click out of the box it doesn't calculate and i can still see the formula! Any extra help? Thank u very much "JE McGimpsey" wrote: One way: =IF(D19="sch","liz",IF(D19="TCh","lex",IF(D19="POS ","mav","other"))) However, you're limited to 7 levels of nesting pre-XL07. You may do better with a lookup. For instance: J K 1 sch liz 2 TCh lex 3 POS mav Then use the formula =VLOOKUP(D19,J:K,2,FALSE) or, if it's possible that D19 has a value not in the table: =IF(ISNA(VLOOKUP(D19,J:K,2,FALSE)),"other",VLOOKUP (D19,J:K,2,FALSE) In article , Be18 wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text IF
Check your other thread.
Be18 wrote: Thanks for your reply. My formula looks like the first one, as i only have five, however when i click out of the box it doesn't calculate and i can still see the formula! Any extra help? Thank u very much "JE McGimpsey" wrote: One way: =IF(D19="sch","liz",IF(D19="TCh","lex",IF(D19="POS ","mav","other"))) However, you're limited to 7 levels of nesting pre-XL07. You may do better with a lookup. For instance: J K 1 sch liz 2 TCh lex 3 POS mav Then use the formula =VLOOKUP(D19,J:K,2,FALSE) or, if it's possible that D19 has a value not in the table: =IF(ISNA(VLOOKUP(D19,J:K,2,FALSE)),"other",VLOOKUP (D19,J:K,2,FALSE) In article , Be18 wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |