114
Pocket Sheet Errors
The message #ERR appears inside of a cell any time one of the following
operations is attempted with the cell.
• Division by zero
• Any mathematical operation that produces a value that exceeds the
calculation limit
• Any mathematical operation in which a cell references itself
• Deletion of a row or column that contains a cell referenced by the cell
• A copy operation that causes the referenced cell to be outside the sheet
• Any copy operation, or row or column insert operation that causes the
length of a function to exceed 256 characters
• Mathematical error
• Adding a large number of mathematical expressions to a sheet for which
Auto Calculation is turned off can cause the #ERR message to appear.
• Parentheses can be nested up to 10 times inside a single calculation.
• Referencing of other cells within the same sheet is limited to 256 levels
per calculation.
Important!
• Referencing a cell that contains a calculation that has not yet been performed
may cause the referencing calculation to take a long time.