Cell Value
A cell's value refers to the content contained within a cell. This maybe a formula
a cell reference
, simple text/numbers or sometimes
error values. Basically it is the values you work with and manipulate within a spreadsheet.
While most cell values are straightforward like text, formulas and cell references, error codes are sometimes harder to understand especially for anyone new in working with spreadsheets.
A few common error values are:
- "#REF" - This refers to an invalid cell reference contained in the cell
- "#VALUE" - This refers to a result of a formula that doesn't conform to a standard format or definition. It may also be caused by a text found within the formula of a cell.
- "#NAME?" - This refers to an identifier that cannot be evaluated.
- "ERR:NNN" - Where "NNN" refers to a three digit number indicating a specific kind of error. You can find the meaning of each error number code by looking at Calc's documentation.
Using Cell Values
The following screencasts demonstrate how to use and manipulate cell values:
- How to enter a value into a cell.
- How to interpret an error value.
- How to debug formula errors.
- How to format a cell horizontally aligned to the center.
- How to align a cell's content vertically to the top.
OpenOffice.org™ is a trademark of OpenOffice.org.
