nested if still has too many arguments

Posted to microsoft.public.excel.misc

Janis

external usenet poster

Posts: 360

nested if still has too many arguments

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3 level nested if has too many arguments ?	Janis	Excel Discussion (Misc queries)	4	September 5th 07 04:59 PM
Nested IF's with Logical Arguments - Doing something wrong here	ConfusedNHouston	Excel Discussion (Misc queries)	1	December 1st 06 03:04 AM
Nested IF's with Logical Arguments - Doing something wrong here	PapaDos	Excel Discussion (Misc queries)	0	November 30th 06 05:13 PM
Nested IF's with Logical Arguments - Doing something wrong here	Dave F	Excel Discussion (Misc queries)	0	November 30th 06 04:03 PM
I have run out of arguments for nested IF statement	christopherp	Excel Discussion (Misc queries)	5	March 19th 06 12:26 PM

All times are GMT +1. The time now is 08:17 PM.

Menu

About Us