Formulas -> Formula Auditing->Error Checking Try
This: Run Error Checking Select Cell
E8. Go to
Formulas -> Formula Auditing. Go to
Error Checking->Trace Error. What Do
You See? The Error Checker found that the formula in Cell E8 is
inconsistent: it is not the same as the formula in the Row above. The
Error Checking Options include: Copy
Formula from Above Help on
this error Ignore
Error Edit in
Formula Bar. If you
have a LOT of problems with your formulas you can use the Previous
and Next buttons to navigate through your Error Checking.
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.1. Audit formulas: Error Checking
|
|
| |
