| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF STATEMENTS NOT WORKING
I have the following
FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF STATEMENTS NOT WORKING
=IF(ISNUMBER(SEARCH("farm",A2)),etc
-- Regards, Peo Sjoblom "Iguss" wrote in message ... I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF STATEMENTS NOT WORKING
That goes something like this:
=IF(ISNUMBER(SEARCH("FARM",A2)),"FEDERAL FARM",IF(ISNUMBER(SEARCH("HOME",A2)),"FEDERAL HOME",IF(ISNUMBER(SEARCH("NATL",A2)),"FEDERAL NATL",""))) Thanks again "Peo Sjoblom" wrote: =IF(ISNUMBER(SEARCH("farm",A2)),etc -- Regards, Peo Sjoblom "Iguss" wrote in message ... I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF STATEMENTS NOT WORKING
Another way:
Create a 2 column table like this: ...........I..........J.......... 1....Farm......FEDERAL FARM CREDIT BANK 2....Home....FEDERAL HOME LOAN BANK 3....Natl.......FEDERAL NATIONAL MORTGAGE CORP Then use this formula: =LOOKUP(2,1/(ISNUMBER(SEARCH(I$1:I$3,A1))),J$1:J$3) -- Biff Microsoft Excel MVP "Iguss" wrote in message ... I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF STATEMENTS NOT WORKING
Yes, I figured you would do the rest yourself
-- Regards, Peo Sjoblom "Iguss" wrote in message ... That goes something like this: =IF(ISNUMBER(SEARCH("FARM",A2)),"FEDERAL FARM",IF(ISNUMBER(SEARCH("HOME",A2)),"FEDERAL HOME",IF(ISNUMBER(SEARCH("NATL",A2)),"FEDERAL NATL",""))) Thanks again "Peo Sjoblom" wrote: =IF(ISNUMBER(SEARCH("farm",A2)),etc -- Regards, Peo Sjoblom "Iguss" wrote in message ... I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF STATEMENTS NOT WORKING
Thank you,
"T. Valko" wrote: Another way: Create a 2 column table like this: ...........I..........J.......... 1....Farm......FEDERAL FARM CREDIT BANK 2....Home....FEDERAL HOME LOAN BANK 3....Natl.......FEDERAL NATIONAL MORTGAGE CORP Then use this formula: =LOOKUP(2,1/(ISNUMBER(SEARCH(I$1:I$3,A1))),J$1:J$3) -- Biff Microsoft Excel MVP "Iguss" wrote in message ... I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF STATEMENTS NOT WORKING
You're welcome!
-- Biff Microsoft Excel MVP "Iguss" wrote in message ... Thank you, "T. Valko" wrote: Another way: Create a 2 column table like this: ...........I..........J.......... 1....Farm......FEDERAL FARM CREDIT BANK 2....Home....FEDERAL HOME LOAN BANK 3....Natl.......FEDERAL NATIONAL MORTGAGE CORP Then use this formula: =LOOKUP(2,1/(ISNUMBER(SEARCH(I$1:I$3,A1))),J$1:J$3) -- Biff Microsoft Excel MVP "Iguss" wrote in message ... I have the following FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP =IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME LOAN BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION",""))) Can you please advise why a following formula doesn't work and how can I correct it. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use "if statements" when working with dates? | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| working with IF statements | Excel Worksheet Functions | |||
| Working with If statements and time | Excel Worksheet Functions | |||
| 4 different if statements, not working | Excel Worksheet Functions | |||
Linear Mode
