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?