View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 3 level nested if has too many arguments ?

Detail your situation.
maybe
if left(c2,4)="uro1","what",if(next
or
=CHOOSE(MID(E2,4,1),5,6,7,8)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Janis" wrote in message
...
I don't see the error:
=if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "")

tia,