Well I'll be damned, they're finally giving us that *million* Row XL.

There's such a major revamping, I wonder if there's anything left that they
*didn't* add, as far as limits are concerned?

Thanks for the link Dave.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
a formula can only contain 1024 characters when measured in R1C1 mode.

Although this is gonna change (as well as the nest limit):
http://blogs.msdn.com/excel/default.aspx

Ron Rosenfeld wrote:

On Thu, 29 Sep 2005 12:43:04 -0700, "DallasM"
wrote:

Lots. It is limited by the 32,767 limit on the length of cell contents.
So
the maximum number of IF's would have a varying limit depending on the
length
of each formula.

However, if you are *nesting* functions, you may only nest seven
functions.
This applies to IF's as well as all the other functions.

--ron

--

Dave Peterson