View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Janis Janis is offline
external usenet poster
 
Posts: 360
Default 3 level nested if has too many arguments ?

sorry I left out some parts, I'll repost.

"Janis" wrote:

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

tia,