On Fri, 6 Jan 2006 15:14:48 -0600, mcr1
wrote:


I am using the following formula and if there is more than 8, it gives
me an error msg each time (and I am sure to add additional )'s at the
end. Any suggestions how I could get it to allow as many as I want.
Thanks in advance.

=IF(F5="1K","51126",IF(F5="2AC","36320",IF(F5="0A P","49003",IF(F5="3AC","36316",IF(F5="9CH","45284" ,IF(F5="1DB","318",IF(F5="6AC","53570",IF(F5="149" ,"1045",""))))))))

I am wanting to be able to put as many as I want. Thanks in advance.

What you're doing is called "nesting", and it has a limit.
Specifically:

"Nesting level limits: A formula can contain up to seven levels of
nested functions."

I suggest that instead of doing it that way, you create a table
somewhere in your workbook and use VLookups to compare F5's value to
that table. It makes for much neater and less error-prone formulas.

[F1] help has a pretty good worked example explaining how to use the
function if you haven't done so before.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *