View Single Post
  #5   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default How many similar functions can be put in one cell?

On Wed, 26 Oct 2005 11:16:06 -0700, "Forrest"
wrote:

I have a formula in one cell with several functions used multiple times. It
seems though that 25 times is the max for the Round function before it blows
up. Why?


The error has nothing to do with the ROUND function. You have run into the
seven level function nesting limitation of Excel.

What are you trying to do? Perhaps someone can suggest an shorter formula.


--ron