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

Chapter 6. Working with Functions > Understanding Common Error Messages

Understanding Common Error Messages

You will find that Calc seems to have an endless supply of error messages. And it always seems to display them when you feel that you've done your utmost to make sure that a particular formula or function has been constructed in the proper manner. Troubleshooting problem formulas and functions can be made easier by recognizing some of the more common error messages. These are listed in Table 6.3.

Table 6.3. Common Error Messages
Error Message Description
503 Invalid floating point operation. Typically appears in cases where division by zero is being calculated.
509 Missing operator. An expected operator is missing from a formula.
510 Missing variable. Two operators are adjacent in a formula and should be separated by a variable.
519 (seen in the cell as #VALUE) A cell referenced in a formula or function is text rather than an expected value.
525 (seen in the cell as #NAME) An identifier could not be recognized. For example, when using one of the LOOKUP functions, a value could not be returned because the lookup item could not be found in the lookup array.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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