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.
|