3 level nested if has too many arguments ?

G

Guest

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

tia,
 
D

Don Guillett

Detail your situation.
maybe
if left(c2,4)="uro1","what",if(next
or
=CHOOSE(MID(E2,4,1),5,6,7,8)
 
G

Guest

I left out the quotation marks. Thanks!

Don Guillett said:
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
(e-mail address removed)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested if still has too many arguments 4
COPY/PASTE/FORMULA GIVES ABSOLUTE REFERENCE 2
nested if contains a syntax error because of a "." 3
NESTED OR FORMULAS 5
Too many arguments for nested IFs 5
Nest Guard has hidden microphone 2
Nested IIf and IsNull 1
Offline Files: Prompt for username/password? 1

Top