Presentation of Nested Formulae
Debugging complex nested formulae and functions within a single cell can be difficult and requires a careful check to be kept on the level of parentheses. As an additional formula auditing tool, instead of presenting a formula in a single line it would be much clearer to present each level of nesting (parentheses) on a lower row. Like this the top level function is presented in the top row, the first level of nesting at the same position along the row the but dropped down a row, etc. so that the formula steps down a row (and up again) as each additional level of nesting is added or closed.
Kevin Green commented
Michael Rudmin commented
This should be combined with suggestion # 10589244, which has 15 votes. The two suggestions are the same. My notes there, would apply here. Link at:
Kenneth Barber commented
Just keep in mind that this separation of nesting levels across to multiple rows does not work well with multi-line formulas.
Also, FormulaDesk does something like what you are suggesting:
A.C. WILSON commented
This has been available for decades for many programming languages, in the editors accompanying their compilers.