how many if statements are allowed per cell?
 

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

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

7 If statements or Functions per cell.

See workarounds at Chip Pearson's site.

http://www.cpearson.com/excel/nested.htm


Gord Dibben Excel MVP

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

On Thu, 29 Sep 2005 15:07:39 -0500, Dave Peterson
wrote:

a formula can only contain 1024 characters when measured in R1C1 mode.

Thanks for the correction.


--ron

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

how many if statements are allowed per cell?
 

Thanks for the site...this is a great work-around!
--
Linda



"Gord Dibben" wrote:

7 If statements or Functions per cell.

See workarounds at Chip Pearson's site.

http://www.cpearson.com/excel/nested.htm


Gord Dibben Excel MVP

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