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
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
Try F9.
Select part of the formula to evaluate and F9.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
xl2003:
Tools|Formula Auditing|Evaluate Formula
xl2007 onwards:
Ribbon, Formulas, Formula Auditing, Evaluate formula.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Pascal,
Have you ever found that function useful? It has always struvck me as a seemingly good idea that actually is no use whatsoever.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.Originally Posted by xld
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.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
The simple dreams of Excel Users, eh Bob? A formula/function decrypter
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link