|
<< Click to Display Table of Contents >> Error values |
If a formula results in an error, an error value is displayed instead of the result.
An example: A division is to be performed in a cell by the content of another cell. This other cell contains a value of 0. PlanMaker cannot perform this division by zero, which is not allowed in mathematics. The error value #DIV/0! will now be displayed in the cell, indicating that a division by zero is being performed.
The following error values exist:
Error value |
Explanation |
#REF! |
Invalid cell reference. Displayed when the formula contains a cell reference that is invalid or nonexistent after deleting cells (e.g. with the ribbon command Home | group Cells | Delete). |
#DIV/0! |
Division by zero. Displayed when a formula contains a division by zero (which is undefined for any number). |
#NULL! |
Invalid formula. Displayed when a formula contains syntax errors (for example, a missing parenthesis or missing arguments). |
#NAME? |
Invalid name. Displayed when a formula refers to a table name or named range that is nonexistent. |
#N/A |
Not available. Displayed when a cell contains a) a #N/A error value, or b) a formula referring to a cell containing a #N/A error value. See NA (error value #N/A) for details. |
#VALUE! |
Invalid value. Displayed when a function is used with an inappropriate parameter type (for example, if a number is passed to a function that is expecting a text string). |
#NUM! |
Invalid number. Displayed when a function is used with a number that is out of range (for example, too large, or negative instead of positive) |
Tip: To test if a cell returns an error value, use the functions ISERROR and ISERR
Tip: Additionally, you can also use the formula auditing from the command group Traces on the ribbon tab Formula to find and analyze cells that contain an error value. For more information, see Analyzing sheets.