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 ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.