Calc Guide

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 144 depicts division of column B by column C yielding
2 errors arising from a zero and a blank cell showing in column C.
Figure 144: 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.
206 OpenOffice.org 3.x Calc Guide