![How to evaluate a nested formula one step at a time How to evaluate a nested formula one step at a time](/images/connexion/evaluateformula.png)
7 February 2014
Sometimes, understanding how a figure is calculated is difficult because the formula seems quite complicated; comprising of several intermediate calculations and logical tests. Luckily Microsoft Excel has a powerful auditing tool, Evaluate Formula, which will help you to unravel the different parts of a formula, in the order that it is calculated, to understand how the end result is constructed.
Full article: How to evaluate a nested formula one step at a time