Excel: how to find and correct errors in formulas
July 18, 2022
When Excel identifies its thought process is an equation that has been placed erroneously, a little green triangle shows up in the upper-left corner of the cell where you entered the recipe. What’s more, on the off chance that the mistake is particularly deplorable, a blunder message, an obscure three-or four-letter show went before by a pound sign (#), shows up in the cell. The table makes sense of normal blunder messages.
To figure out more about a recipe mistake and maybe right it, select the cell with the green triangle and snap the Error button. This little button shows up next to a cell with an equation blunder after you click the cell, as displayed here. The drop-down list on the Error button offers open doors for adjusting equation mistakes and figuring out additional about them.
Running the blunder checker
One more method for handling equation mistakes is to run the blunder checker. At the point when the checker experiences its thought process is a blunder, the Error Checking exchange box lets you know the mistake, as displayed.
To run the blunder checker, go to the Formulas tab and snap the Error Checking button (you might need to tap the Formula Auditing button first, contingent upon the size of your screen).
On the off chance that you see plainly what the mistake is, click the Edit in Formula Bar button, fix the blunder in the Formula bar, and snap the Resume button in the exchange box (you find this button at the highest point of the discourse box). On the off chance that the mistake isn’t one that actually needs remedying, either click the Ignore Error button or snap the Next button to send the blunder checker looking for the following mistake in your worksheet.
Following cell references
In a perplexing worksheet in which equations are heaped on top of each other and the consequences of certain recipes are processed into different equations, it assists with having the option to follow cell references. By following cell references, you can perceive how the information in a cell considers along with an equation in another cell; or on the other hand, on the off chance that the cell contains a recipe, you can see which cells the recipe accumulates information from to make its calculation. You can find out about how your worksheet is developed, and in this manner, find primary mistakes all the more without any problem.
The accompanying figure shows how cell tracers portray the connections between cells. A cell tracer is a blue bolt that shows the connections between cells utilized in equations. You can follow two kinds of connections:
Following points of reference: Select a cell with a recipe in it and follow the equation’s points of reference to figure out which cells are registered to deliver the consequences of the equation. Follow points of reference when you need to find out where a recipe gets its calculation information. Cell tracer bolts point from the referred to cells to the cell with the recipe brings about it.
To follow points of reference, go to the Formulas tab and snap the Trace Precedents button (you might need to tap the Formula Auditing button first, contingent upon the size of your screen).
Following wards: Select a cell and follow its wards to figure out which cells contain recipes that utilization information from the cell you chose. Cell tracer bolts point from the cell you chose to cells with recipe brings about them. Follow wards when you need to figure out how the information in a cell adds to equations somewhere else in the worksheet. The cell you select can contain a steady worth or a recipe by its own doing (and contribute its outcomes to another equation).
To follow wards, go to the Formulas tab and snap the Trace Dependents button (you might need to tap the Formula Auditing button first, contingent upon the size of your screen).