Is it possible to nest more than 7 arguments in one function?
 

I'm trying to get excel to do a large IF logical function where I turn 14
different lengths each into a two digit code. Is there any way to get past
the limit of 7 nested arguments?

Hi,

Post the data and what you are trying to do. There might be alternative
formulas which you can use.

Govind.

Summer Scobell wrote:
I'm trying to get excel to do a large IF logical function where I turn 14
different lengths each into a two digit code. Is there any way to get past
the limit of 7 nested arguments?

Don't bother trying is the usual advice. If it's hard then there's often a
reason, and the usual reason is that there is an easier solution. Take a
look at VLOOKUP which is usually the better option for this kind of
scenario. that having been said, with no sample data it's kind of hard to
fully make the call.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Summer Scobell" <Summer wrote in message
...
I'm trying to get excel to do a large IF logical function where I turn 14
different lengths each into a two digit code. Is there any way to get
past
the limit of 7 nested arguments?

It depends on what you are trying to accomplish. Here are a couple
possibilities:

=if(a1=2,"Yes ","")&if(a1=3,"you ","")&if(a1=4,"can.","")&if(..............

Or

=if(a1=2,3,0)+if(a1=3,4,0)+if(a1=4,5,0)+if(....... .......

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Summer Scobell" <Summer wrote in message
...
I'm trying to get excel to do a large IF logical function where I turn 14
different lengths each into a two digit code. Is there any way to get
past
the limit of 7 nested arguments?