| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF statements
I am having difficulty debuging some code. I am wandering if I am simply
trying to nest to many If statements. The code is as follows: ActiveCell.FormulaR1C1 = _ "=IF(LEFT(RC[1],9)=""NASCO/REP"",""BLANK"",IF(LEFT(RC[1],5)=""HERTZ"",""HERTZ"",IF(LEFT(RC[1],5)=""DALLAS"",""DALLAS"",IF(LEFT(RC[1],5)=""ALFAX"",""ALFAX"",IF(LEFT(RC[1],5)=""OF/US"",""OFUSA"",IF(LEFT(RC[1],5)=""QUILL"",""QUILL"",IF(LEFT(RC[1],5)=""NASCO"",""NASCO"",IF(LEFT(RC[1],5)=""DOANE"",""TERA"",IF(LEFT(RC[1],3)=""NBF"",""NBF"",IF(LEFT(RC[1],3)=""IS-"",""IS"",""K"")))))))))))" Do I need to find a way to do this w/o clumsy If's? Josh josh.eades atgmaildotcom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NESTED IF STATEMENTS | New Users to Excel | |||
| Nested If/Then statements | Excel Worksheet Functions | |||
| Help with Nested If Statements | Excel Discussion (Misc queries) | |||
| nested if statements | Excel Programming | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
