Calc Guide

NAME? (525) No valid reference exists for the argument.
REF (525) The column, row, or sheet for the referenced cell is missing.
VALUE (519) The value for one of the arguments is not the type that the
argument requires. The value may be entered incorrectly; for
example, double-quotation marks may be missing around the value.
At other times, a cell or range used may have the wrong format,
such as text instead of numbers.
509 An operator such as an equals sign is missing from the formula.
510 An argument is missing from the formula.
502 The column, row, or sheet for the referenced cell is missing.
Examples of common errors
Err:503 Division by zero
This error is the result of dividing a number by either the number zero (0) or a blank
cell. There is an easy way to avoid this type of problem. When you have a zero or
blank cell displayed, use a conditional function. Figure 160 depicts division of column
B by column C yielding 2 errors arising from a zero and a blank cell showing in
column C.
Figure 160: Examples of Err:503, Division by zero
It is very common to find an error such as this arising from a situation where data
was not reported or reported incorrectly. When such an occurrence is possible, an IF
function can be used to display the data correctly. The formula =IF(C3>0, B3/C3,
"No Report") can be entered. The formula is then copied over the remainder of
Column D. The meaning of this formula roughly would be: “If C3 is greater than 0,
then compute B3 divided by C3, otherwise enter ‘No Report’”.
It is also possible for the last parameter to use double quotes for a blank to be
entered, or a different formula with a standardized number being substituted for the
lower number. An example of this might be to use the nursing staff in the unit.
Chapter 7 Using Formulas and Functions 183