Tool or editor require for understanding return value of each argument of so many nes

[aligahk06]

Dear Valuable member,
Is there any tool or add in that can help us to understand the complex formula in excel.
i.e it shows the step by step return value of the each argument of the function.

Please advise!

Rgds,
Aligahk06

[Bob Phillips]

Try F9.

Select part of the formula to evaluate and F9.

[p45cal]

xl2003:
Tools|Formula Auditing|Evaluate Formula
xl2007 onwards:
Ribbon, Formulas, Formula Auditing, Evaluate formula.

[Bob Phillips]

Pascal,

Have you ever found that function useful? It has always struvck me as a seemingly good idea that actually is no use whatsoever.

[p45cal]

Pascal,

Have you ever found that function useful? It has always struvck me as a seemingly good idea that actually is no use whatsoever.

Well, I suppose it's what you're used to, I could highlight parts of the formula and press F9 and get similar info. I use it when a formula stubbornly returns an error and I want to know where that error is introduced.

It also shows the order in which calculations are done in a formula, 'though I wish it had a back button instead of just moving forwards with the Evaluate button.

[Bob Phillips]

I have always found it unhelpful, because it evaluates the the true path, which I is rarely why I am looking at a formula. I can do that with F9, as well as looking at False path elements.

[Aussiebear]

The simple dreams of Excel Users, eh Bob? A formula/function decrypter