View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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