Excel add-in that makes Excel formulas easy to understand, check, troubleshoot and fix.

Languages: English | File Size: 14 MB

Надстройка для Excel, которая делает формулы в Excel простыми для понимания, проверки, поиска ошибок и исправления.

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.

Home Page - https://www.formuladesk.com/formulaspy/

Download from file storage

FormulaDesk FormulaSpy 1.39 + crack