Investment Studio > Objects > Grid > Error codes

When the Grid object is set not to show errors ( not depressed in the Grid toolbar; Show errors item not checked in pop-up menu's Layout submenu), cells without valid values are blank.

Cells may display the special error code ##### independently of the Grid's "Show error" setting. Unlike the error codes listed below, ##### doesn't denote an invalid cell value. Instead, it means that the cell value can't be displayed within the current cell size (cell width for alphanumeric data, e.g. strings or numbers; height and width for images).

When the Grid object is set to show errors, the following error codes are displayed in cells without a valid value:

#ERR Generic error, shown when no further information about the error is available.
#BUSY! Computation of the cell's value hadn't been completed when the cell was drawn.
#N/A Value (e.g. a function argument) not available.
#NAME? The formula contains an unrecognized name (symbol, function). Check your spelling!
#(? The formula contains an unmatched left parenthesis.
#?) The formula contains an unmatched right parenthesis.
#{? The formula contains an unmatched left curly bracket (array delimiter).
#?} The formula contains an unmatched right curly bracket (array delimiter).
#OP? An operator is missing in the formula, i.e. two values appear next to each other with no operator between them (e.g. "1 2" instead of "1 + 2").
#DIV/0! Division by zero.
#NULL! The formula specifies an intersection of two cell ranges that do not intersect.
#NUM! Invalid number, e.g. a numeric function argument outside the valid range or a numeric result that is too small, too large, or can't be found (e.g. when solving an equation).
#REF! The formula contains an invalid cell reference.
#CIRC! The cell contains a circular reference: its value depends on the value of another cell, which in turn depends on the value of the first cell (either directly or indirectly, i.e. through other cells).
#VALUE! A function or operator is used with the wrong type or number of arguments.