| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if still has too many arguments
It still has too many arguments. Is it the ending "" null values? I tried
it without and with i.e. ,""),""),""),""). =IF(LEFT(C2,4),"ur01","88.89.251.188",IF(LEFT(C2,4 ),"ur02","88.89.251.189",IF(LEFT(C2,4),"ur03","88. 89.251.192",if(left(C2,4),"ur04","88.89.251.193")) )) tia, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested if still has too many arguments
Please don't start a new thread - re-post to the first thread.
Your syntax is wrong =IF(LEFT(C2,4),"ur01" has to be changed to =IF(LEFT(C2,4)="ur01" "Janis" wrote: It still has too many arguments. Is it the ending "" null values? I tried it without and with i.e. ,""),""),""),""). =IF(LEFT(C2,4),"ur01","88.89.251.188",IF(LEFT(C2,4 ),"ur02","88.89.251.189",IF(LEFT(C2,4),"ur03","88. 89.251.192",if(left(C2,4),"ur04","88.89.251.193")) )) tia, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested if still has too many arguments
Or second thread!
Duke Carey wrote: Please don't start a new thread - re-post to the first thread. Your syntax is wrong =IF(LEFT(C2,4),"ur01" has to be changed to =IF(LEFT(C2,4)="ur01" "Janis" wrote: It still has too many arguments. Is it the ending "" null values? I tried it without and with i.e. ,""),""),""),""). =IF(LEFT(C2,4),"ur01","88.89.251.188",IF(LEFT(C2,4 ),"ur02","88.89.251.189",IF(LEFT(C2,4),"ur03","88. 89.251.192",if(left(C2,4),"ur04","88.89.251.193")) )) tia, -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested if still has too many arguments
Okay, thanks.
"Duke Carey" wrote: Please don't start a new thread - re-post to the first thread. Your syntax is wrong =IF(LEFT(C2,4),"ur01" has to be changed to =IF(LEFT(C2,4)="ur01" "Janis" wrote: It still has too many arguments. Is it the ending "" null values? I tried it without and with i.e. ,""),""),""),""). =IF(LEFT(C2,4),"ur01","88.89.251.188",IF(LEFT(C2,4 ),"ur02","88.89.251.189",IF(LEFT(C2,4),"ur03","88. 89.251.192",if(left(C2,4),"ur04","88.89.251.193")) )) tia, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested if still has too many arguments
="88.89.251."&VLOOKUP(LEFT(C2,4),{"ur01",188;"ur02 ",189;"ur03",192;"ur04",193},2,0)
"Janis" wrote: It still has too many arguments. Is it the ending "" null values? I tried it without and with i.e. ,""),""),""),""). =IF(LEFT(C2,4),"ur01","88.89.251.188",IF(LEFT(C2,4 ),"ur02","88.89.251.189",IF(LEFT(C2,4),"ur03","88. 89.251.192",if(left(C2,4),"ur04","88.89.251.193")) )) tia, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 level nested if has too many arguments ? | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
| I have run out of arguments for nested IF statement | Excel Discussion (Misc queries) | |||
Linear Mode
