Calc Guide

General error codes
The following table is an overview of the most common error messages
for OOo Calc.
Note
Errors described as Internal errors should not be encountered by
users under normal conditions. Errors listed as Not used are not
currently assigned to any error condition and will not occur.
Code Message Explanation of the error
501 Invalid character Character in a formula is not valid. This error
is the same as the Invalid Name error (525)
except that it occurs within a formula. The cell
containing the error will display the #NAME?
error reference.
502 Invalid argument Function argument is not valid; for example, a
negative number for the root function. This
error also occurs if more than one matching
cell is found by the DGET function.
503 Invalid floating
point operation
(cell displays
#NUM!)
Division by 0, or another calculation that
results in an overflow of the defined value
range (a value too big or too small).
504 Parameter list
error
Function parameter is not valid; for example,
text instead of a number, or a domain
reference instead of a cell reference.
505 Internal syntax
error
Not used.
506 Invalid
semicolon
Not used.
507 Pair missing Not used.
508 Pair missing Missing bracket or parenthesis; for example,
closing brackets but no opening brackets.
509 Missing operator Operator is missing; for example,
"=2(3+4) * ", where the operator between
"2" and "(" is missing.
510 Missing variable Variable is missing; for example, when two
operators are together "=1+*2".
511 Missing variable Function requires more variables than are
provided; for example, AND() and OR().
Appendix C Calc Error Codes 487