Thread: nested if still has too many arguments
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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 With QuoteReply With Quote