NewDeal Hot Tip 1004

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.

Last Modified 28 Feb 1999