OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 184)

Figure 161: 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.

The Detective

In a long or complicated spreadsheet, color coding becomes less useful. In these

cases, consider using the the submenu under Tools > Detective. The Detective is a

tool for checking which cells are used as arguments by a formula (precedents) and

which other formulas it is nested in (dependents), and tracking errors. It can also be

used for tracing errors, marking invalid data (that is, information in cells that is not

in the proper format for a function’s argument), or even for removing precedents and

dependents.

184 OpenOffice.org 3.3 Calc Guide

1 2 ... 179 180 181 182 183 184 185 186 187 188 189 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 184