Description: Trace error will point to the root of the error. If the cells display some error message and the data in the cell combined of some complex formulas, then it is difficult to find out the real cause for the error. Trace error will trace the error till its original position.
In the below example, K14 having error message. For tracing the error, select Error Checking option under Formula Auditing section under Formula tab. Select Trace Error option from the Error Checking window. This will trace the root cell or till the cell which caused the error.
_1102.jpg)
_1099.jpg){kind=small}
No comments:
Post a Comment