Not sure what you meant exactly, but you can use the evaluate formula tool (under the formula ribbon) to see how your formula calculates and verify that it's working as you planned.
See related links for a video that shows you how:
To activate Range Finder in Google Sheets, click on an empty cell where you want to display the result, then navigate to "Add-ons" > "Range Finder" > "Start". To verify a formula in a cell, hit the "Ctrl" key (or "Cmd" on Mac) while clicking the cell with the formula, then select "Insert Note" to add a note and any additional explanations.
Range finder. Double clicking on the formula activates the range finder and you can see what cells are in the formula. This can help you see if the correct cells are in the formula.
True
True
Range Finder
The Range Finder feature is enabled when a user creates a new formula or edits an existing formula. The Range Finder gives users better visual feedback for moving and resizing the Range Finder range. You can see the ranges included in the formula are highlighted by different color border lines.
range finder
The range finder will show what cells are included. However, as only the user can know what the formula is meant to be and what cells should be included, you cannot say that the range finder verifies the cells that are intended. The range finder just lets the user see what cells have been included and then the user can accept them or change the cells that are selected.
range finder
There is a formula auditing toolbar and there are options that can be used. By clicking on a formula to edit it, you can see the range finder highlighting the cells being used in the formula.
There is a formula auditing toolbar and there are options that can be used. By clicking on a formula to edit it, you can see the range finder highlighting the cells being used in the formula.
A person can purchase a Leupold Range Finder at stores such as Walmart or online. Some online sites that sell the Leupold Range Finder include Amazon, MidwayUSA and eBay.