Thanks Dave

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

All the best,

Alex

"Dave F" wrote:

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.
--
Brevity is the soul of wit.


"Alex" wrote:


does anybody reccomend any add-in and/or best practice to grapple with long
command statements ?

All the best,

Alex