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