Calc Guide

Figure 145: Division by zero solution
#VALUE Non-existent value and #REF! Incorrect references
The non-existent value error is also very common. The most common
appearance of this error arises when a user copies a formula over a
selected area. When copying, it is typical for the program to increment
the represented cells. If you were copying downward from cell B3 the
program would automatically substitute the cell B4 into the next lower
cell and so on until the end of the copying process. If that next cell
contains text or a value that is inappropriate for the formula, then this
error may result. The difficulty usually occurs when one or more of the
parameters in the formula need to be fixed.
Note
To avoid the #VALUE and #REF! errors, give the cell B3 a name
such as TotalExpenses. In that way, the program will carry that
name to each succeeding formula being copied and remove the
need to use the $ to anchor the reference to the TotalExpenses
cell.
Color coding for input
Another useful tool when reviewing a formula is the color coding for
input. When you select a formula that has already been entered, the
cells or ranges used for each argument in the formula are outlined in
color.
Calc uses eight colors for outlining referenced cells, starting with blue
for the first cell, and continuing with red, magenta, green, dark blue,
brown, purple and yellow before cycling through the sequence again.
Chapter 7 Using Formulas and Functions 207