View Single Post
  #12   Report Post  
Harlan Grove
 
Posts: n/a
Default How many similar functions can be put in one cell?

Forrest wrote...
Can you point out at where the nesting is being exceeded? I have only seven
nested if statements. The equation converts meters into feet, inches and
fractions of an inch to the nearest eighth. It works fine if I spilt it into
2 cells, but I don't want that.

....

It's not a limitation on the number of nested IF calls, it's a
limitation on the number of nested *function* calls. Your formula tries
to go 10 levels deep.