NewDeal Hot Tip 1004
NewCalc
NewCalc Display Codes
When NewCalc cannot display a value or the result of a function,
it puts a code in the cell composed of or surrounded by pound
signs (hash marks).
- ###
- The cell is too narrow to display the contents (you
need to widen the column).
- #COUNT#
- A function was used with the wrong number of arguments.
- #CIRC#
- The formula contains a circular reference (the formula
references the cell itself).
- #ERROR#
- The cell contains a formula that the parser cannot interpret.
- #NAME#
- The cell contains a formula that appears to use an undefined
name. (If you are not using cell names, then there is probably a syntax
error in your formula.)
- #TYPE#
- You are providing a number when the function expects a string
or you are providing a string when it expects a number.
- #N/A#
- This is returned only by the NA() function.
- #VALUE#
- The result of the computation is too large or too small
for the math library.
Return to Index
Last Modified 28 Feb 1999