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