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.
Last Modified 1 Nov 1999
©2000 NewDeal Inc. All rights reserved
Eine Seite zurück |