• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Automating Calculations with ... > Troubleshooting Errors in Formulas

Troubleshooting Errors in Formulas

When you enter a formula or function correctly, the cell that contains the formula or function displays the correct result of the equation. If the result is incorrect or the cell displays one of the error messages described in Table 6.1, the formula or function has a problem.

Table 6.1. Formula and Function Error Messages
Error MessageIndicates
####Cell is too narrow to display the result.
#VALUE!The wrong type of function, argument, or operand is in use.
#DIV/0!The formula or function calls on Excel to divide a value by zero. In math, you are never allowed to divide a number by zero.
#NAME?Excel does not recognize a cell reference or other text in the formula or function. Usually caused by a typo.
#N/AA particular value inside the formula or function is unavailable to it.
#REF!The formula or function contains an invalid cell reference.
#NUM!A numerical value inside the formula or function is invalid.
#NULL!The formula or function references an intersection of two ranges that do not intersect. Usually indicates that the formula has a space between two cell references instead of an operator or comma.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint