nested if still has too many arguments

G

Guest

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,
 
G

Guest

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"
 
D

Dave Peterson

Or second thread!

Duke said:
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"
Click to expand...
 
G

Guest

Okay, thanks.

Duke Carey said:
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"
Click to expand...
 
G

Guest

="88.89.251."&VLOOKUP(LEFT(C2,4),{"ur01",188;"ur02",189;"ur03",192;"ur04",193},2,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 level nested if has too many arguments ? 4
COPY/PASTE/FORMULA GIVES ABSOLUTE REFERENCE 2
nested if contains a syntax error because of a "." 3
Help with complex "IF" formula !!! 2
Logic to check a range for an existing sequence? 4
NESTED OR FORMULAS 5
Oversensitive touchpad on modern laptops 0
Iserror - too many arguments 2

Top