how many if statements are allowed per cell?

[Ron Rosenfeld]

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


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]

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

 

[Gord Dibben]

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

 

[Ron Rosenfeld]

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

Thanks for the correction.


--ron

 

[RagDyer]

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.

 

[Linda]

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