| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement help needed
Hi;
I get an error when I use the following statement: =IF(ISNUMBER(SEARCH("Cost Center",E12)),"A",IF(ISNUMBER(SEARCH("OM",E12)),"B ",IF(ISNUMBER(SEARCH("Bank Information",E12)),"C",IF(ISNUMBER(SEARCH("Departm ent",E12)),"D",IF(ISNUMBER(SEARCH("Promotion",E12) ),"E",IF(ISNUMBER(SEARCH("Reports To",E12)),"F",IF(ISNUMBER(SEARCH("SAL",E12)),"G"," Not OK"))))))) The error message is as follows: The formula you type contains an error Can anyone help me with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed would this be an IF statement | Excel Worksheet Functions | |||
| Another IF statement needed | Excel Worksheet Functions | |||
| If Statement - Help Needed | Excel Discussion (Misc queries) | |||
| much needed If/or statement help | Excel Discussion (Misc queries) | |||
| If statement needed | Excel Worksheet Functions | |||
Threaded Mode
