FormulaDesk FormulaSpy 1.39
FormulaDesk FormulaSpy 1.39 Download
Excel add-in that makes Excel formulas easy to understand, check, troubleshoot and fix.
X-ray for Excel formulas Instantly understand and troubleshoot complex Excel formulas
SEE FORMULA STEPS AND CALCULATIONS
The horizontal view displays the result of each part of a formula in order to see how the result is calculated. You can also expand and collapse the formula parts by clicking the green result bar.
The vertical view displays a formula as a tree of the parts of a formula. The parts can be expanded and collapsed.
PINPOINT ERRORS INSTANTLY
Excel tells you when a formula has an error, but that’s it. Long formulas are even worse…where do you even start to track down the problem?
Now, FormulaSpy will pinpoint EXACTLY where the error is – no more guessing or wasting hours of your precious time.
DRILLDOWN INTO REFERENCED CELLS (PRECEDENTS)
Explore the cells that the formula uses, visit them and see their formulas, then drill into their references to gain a deep understanding of the entire calculation chain.
Modern formula editor Live editor with instant feedback.
INSTANT FORMATTING
Format the formula at any time by clicking the ‘Format” button. This will auto-indent the formula to make it easier to read.
GOOD / BAD INDICATOR
As you edit the formula, the border will turn green or red to indicate whether the formula is valid or not, making it very easy to check your formula for completeness.
Focus child (nested) formula
Click the ‘Focus’ button to syntax highlight only the formula that contains the cursor – color all other parts of the formula a light gray. This makes it easier to see which part of a fromula you’re working on.
