Returns the "value not available" error, `#N/A`.
=NA()into a cell is equivalent to directly entering the error value
#N/Ais used to mark missing information and to indicate to functions operating on ranges or cells containing such values to halt calculation. For instance, if cell
B2contained the result of an
B2was subsequently involved in a sum or other formula, that formula would assume that
B2held the correct information. By altering the formula in
=IF(ISBLANK(A1),NA(),A1), any subsequent operation on
B2would halt upon encountering the
#N/Aerror, and return that error.
#N/Aerrors indicate missing information and signal functions to cease calculation. Use the
#N/Avalue instead of
0or the cell's results. For example, if
A1contains the value
=NA(), the formula
=A1+A2will evaluate to
ISNA: Checks whether a value is the error `#N/A`.
ISERROR: Checks whether a value is an error.
ISERR: Checks whether a value is an error other than `#N/A`.
Checks the validity of the data before further computing, in order to avoid mis-calculation.