![]() ![]() At any rate, what you want to do is select the cell with the error, and after checking all those typical errors, do Tools Auditing Trace Precedents and/or Trace Error. ![]() If you have DIV/0!, I do not, so look for a variable that somehow did not get filled in with a value perhaps. Possibly, a Defined Name is wrong - they need to be input into the formulas exactly as they were defined. Look for a typo in a formula or unmatched parentheses. If the instructions have been completed and there are still errors, select the cell that has the error value that is furthest left and topmost first. ![]() ERRORS: If you have errors or error values, either the sheet in incomplete and needs further input or Lookup Tables for critical variables or perhaps you've made a mistake somewhere along the line.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |