3 level nested if has too many arguments ?

's Computer Specifications

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

tia,

's Computer Specifications

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,

's Computer Specifications

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 Removed)
"Janis" <(E-Mail Removed)> wrote in message
news:E945D181-B7A2-4D93-83FC-(E-Mail Removed)...
>I don't see the error:
> =if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "")
>
> tia,

's Computer Specifications

I left out the quotation marks. Thanks!

"Don Guillett" wrote:

> 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 Removed)
> "Janis" <(E-Mail Removed)> wrote in message
> news:E945D181-B7A2-4D93-83FC-(E-Mail Removed)...
> >I don't see the error:
> > =if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "")
> >
> > tia,
>
>

's Computer Specifications

try out the choose formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Janis" <(E-Mail Removed)> wrote in message
news:30C2E1E5-6EEA-44DA-AADD-(E-Mail Removed)...
>I left out the quotation marks. Thanks!
>
> "Don Guillett" wrote:
>
>> 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 Removed)
>> "Janis" <(E-Mail Removed)> wrote in message
>> news:E945D181-B7A2-4D93-83FC-(E-Mail Removed)...
>> >I don't see the error:
>> > =if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""),
>> > "")
>> >
>> > tia,
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Too many arguments for nested IFs	Marie FP	Microsoft Excel Misc	5	1st Mar 2008 02:36 AM
nested if still has too many arguments	=?Utf-8?B?SmFuaXM=?=	Microsoft Excel Misc	4	5th Sep 2007 06:02 PM
I have run out of arguments for nested IF statement	christopherp	Microsoft Excel Misc	5	19th Mar 2006 12:26 PM
Nested If(AND..........9 arguments required	=?Utf-8?B?YXhlbA==?=	Microsoft Excel Worksheet Functions	2	22nd Apr 2004 07:31 AM
nested if(and(3 arguments inside)	=?Utf-8?B?bmF0YWxpYQ==?=	Microsoft Excel Worksheet Functions	3	22nd Apr 2004 04:37 AM