The tab button Formula Breakdown gives you information on all formulas used in your spreadsheet. All formulas are presented as search results in list. You can filter these search results on worksheets, risk level and other characteristics to directly show the formulas you’re looking for. You can also search for a formula of a specific cell by choosing a worksheet and putting in the specific cell location.
Clicking on a formula shows you the formula breakdown. This lists all cells that make use of this specific formula. By clicking on cells, you’re shown how the formula works from cell to cell. In short, you’re literally breaking down the formula into all its separate elements.
Watch our video tutorial how to use the Formula Breakdown feature.
Excel Formula Validation and Risk Assessment
Formula Breakdown also shows you all risks that are tied to the use of your formulas. Similar to the Risk Validation feature, PerfectXL assesses all situations with regards to formulas that could be faulty. These risks for error are divided in direct risks and indirect risks. Direct risks are marked by a closed triangle and are directly related to the formula. Indirect risks are risks found in underlying formulas and are marked by an open triangle. “Direct” and “indirect” shouldn’t be seen as indications of the severity of the risk, as an error in an underlying formula can screw up a cell result just as much as a mistake in the main formula.
The tab button Constants shows you a list of all constant values that are being used by the formulas of your spreadsheet. Like with Formula Breakdown, these constants are put in a list that can be filtered by worksheet or cell value range. Clicking on a constant shows you all cells and their related formulas that make use of the constant.
Tutorial Formula Breakdown
Discover how your formula works, by using PerfectXL's Formula Breakdown option. Read the Formula Breakdown tutorial to see how it works!