NA

InformationExcel 2007

Return the #N/A error on purpose (e.g. to leave a gap in a chart).

Syntax

NA()

Examples

=IF(A2=0, NA(), A2)

→

Related functions

ISNA IFNA

More Information functions

CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.