What Is a Tracking Error?
The method is used incorrectly or other reasons cause calculation errors, preventing the information from returning the correct value. It is mainly expressed as the function formula calculation method of EXCEL software.
Wrong value
- Chinese name
- Wrong value
- Nature
- Calculation method
- Features
- Prevent information from returning the correct value
- Application
- Calculation method of function formula in EXCEL software
- Error flag
- Error indicator
- The method is used incorrectly or other reasons cause calculation errors, preventing the information from returning the correct value. It is mainly expressed as the function formula calculation method of EXCEL software.
- when
- The worst result of error values is that they can be transmitted to other formulas. If a formula returns an error value to one cell, another formula in another cell will reference the value calculated by the first formula, and the second These formulas return the same error value and pass them down sequentially.
- When a cell calculates an error value, an error indicator (usually a dark green triangle) appears in the upper left corner of the cell. When this cell is selected, a prompt button appears next to it. When the mouse is moved to the button When you click, a corresponding error message will pop up. After clicking, a menu will pop up, displaying the error name and other related information.
- When using "Formula Evaluation", in the "Formula Evaluation" dialog box, when the evaluation to the underlined part (the part to be evaluated) will fail, the dialog box will remind the lower part that "the next evaluation will occur. "Error" to let users know where the error occurred and why.
- When using "Track Error", the current
- Once an error value appears in the cell, the user must know what caused the error and edit this formula in the way described above to eliminate the error.
- Click the error prompt button next to the error cell, a menu will pop up. Then select "Show calculation steps" or "Tracking errors" to use "Formula evaluation" or "Tracking errors" to find out the cause and location of the error (or use " Formula evaluation "toolbar or use the menu bar tools ==> formula review), when" formula evaluation "reminds" the next evaluation will produce an error "in the lower part, you need to see the error to edit the formula; when tracking When an error occurs, the tracking arrow will be displayed and point to the cell referenced by the current formula. Double-click the tracking arrow to move between the cells involved in the error. Use the "Track Error" function to find the cause of the error and edit it as soon as possible Formula to eliminate errors.
- You can also use ctrl + `to view the original formula to see where the error occurred and eliminate the error. But after editing, press ctrl +` again to return to the formula result.