I'm trying to build a logic statement and reaching the limits of this "file
format."

I'm not sure what this means, nor how I can get around it.
Any help would be appreciated!

If you are refereing to a worksheet formula the limits is 256 characters and
seven nexted IF's. There are ways to reduyce the number of nested IF's if
the is your problem

You can find all the excel limitations by using the worksheet help under:

Excel specifications and limits



"Yardlad" wrote:

I'm trying to build a logic statement and reaching the limits of this "file
format."

I'm not sure what this means, nor how I can get around it.
Any help would be appreciated!

On Tue, 29 Jul 2008 16:01:02 -0700, Yardlad
wrote:

I'm trying to build a logic statement and reaching the limits of this "file
format."

I'm not sure what this means, nor how I can get around it.
Any help would be appreciated!


What error message did you receive?

Is this a worksheet issue, or a VBA issue (the programming group is usually for
VBA related problems)?

Examples of your code, data, expected results and actual results would also be
helpful, as well as a better explanation of what you are trying to do.

Since you post so little detail, it is hard to know what *YOU* mean. But if
you are trying to increase the nesting levels of a worksheet function, you
cannot other than what is listed in the specifications for the version of Excel
you are using. (Seven for Excel 2003 and previous; 64 for Excel 2007.

It is likely you can build your logic statement using a different technique,
that does not require excessive nesting.

If you are building this in VBA, you'll need to be more specific about the
error message and what you are trying to do.
--ron