nested if still has too many arguments

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
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"
 
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...
 
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...
 
Back
Top