"Reading"the logic behind too-long command statements

[Guest]

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

All the best,

Alex

 

[Guest]

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.

 

[Guest]

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