PDA

View Full Version : Tool or editor require for understanding return value of each argument of so many nes



aligahk06
07-26-2010, 01:23 AM
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
07-26-2010, 01:45 AM
Try F9.

Select part of the formula to evaluate and F9.

p45cal
07-26-2010, 02:19 AM
xl2003:
Tools|Formula Auditing|Evaluate Formula
xl2007 onwards:
Ribbon, Formulas, Formula Auditing, Evaluate formula.

Bob Phillips
07-26-2010, 04:22 AM
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
07-26-2010, 07:21 AM
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
07-26-2010, 08:47 AM
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
07-27-2010, 01:05 AM
The simple dreams of Excel Users, eh Bob? A formula/function decrypter