Not sure what you're asking here. Are you referring to long formulas in the
formula bar?
The best way to understand their logic is to split the formula into
bite-size chunks, understand what those chunks do, and then figure out how
all of them work together.
Acctually I was looking for ways (by meand of add-ins &/or best practices)
of accomplishing the parsed understanding of a too-long formula in the
formula bar.
It seems there are 2 alternatives for that:
1) Using Excel Formula Evaluator ( Tools=>Formula Auditing=>Evaluate Formula)
2) Selecting the cell, pressing F2, higlight a portion of the formula and
pressing F9
