trace cell formula errror in Excel

Q79. In Excel, one of my formulas has returned an error - how can I trace the error to fix it?

For example, in the Table below, I get "#N/A" result in 2 of the fields that I do not expect. In Excel, how can I trace the error?

Tracing an error in Excel in very important and Excel gives you the unique error checking menu that will show you where the error comes from

excel trace cell formula error

To do it in Excel, here is the answer:

a) Click on the cell with Error and then click on "Error Checking" under "Formulas". Click on "Trace Error".

excel excel trace cell formula error

b) "Arrows" indicating the cells involved show up which can then be used for verification. Comparing the lookup value in I3 with the corresponding value in the table in D11, it is clear that the value in I3 is misspelt.

Fix the incorrect value in "I3". The arrows disappear automatically.

excel excel excel trace cell formula error

c) Alternatively, arrows can be removed manually even if the problem is not identified and fixed. Click on "Remove Arrows" under "Formulas". Click on "Remove Arrows".

excel excel excel excel trace cell formula error

d) As shown below, arrows are removed even if the error is not fixed.

excel excel excel excel excel trace cell formula error

 

You can find similar Excel Questions and Answer hereunder

1) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

2) How can I avoid updates to cell values during macro execution?

3) how to write a formula in Excel

4) How can I clear cell after activating a routine when there is a change in value of a cell?

5) How can I find the last used cell in a Column in VBA?

6) How to read a value from a cell in vba in Excel

7) How do I know which cells on the worksheet contain Conditional Formatting?

8) How can I calculate values applying complex Engineering formulas using Excel?

9) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

10) Formula does not calculate in Excel

11) How do i apply a formula to an entire column in Excel

12) How can I enter multiple lines of data in a cell?

13) Highlight row of selected cell in Excel

14) How do I enter a formula in a cell using VBA (using Absolute Reference)?

15) How can I quickly navigate to a frequently used field in a voluminous worbook?