Author: Oscar Cronquist Article last updated on April 19, 2018

The NA() function returns the error value #N/A meaning "value is not available".

Formula in cell B3:

=NA()

Excel Function Syntax

NA()

Arguments

The NA() function has no arguments.

Comments

Use the NA() function to fill empty cells to avoid including empty cells in your calculations.

Use the ISNA or IFNA function to identify #N/A errors.

How to use the ISNA function

The ISNA function returns TRUE if value is a #N/A error. Formula in cell C3: =ISNA(B3) Excel Function Syntax ISNA(value) […]

How to use the IFNA function

The IFNA function handles #N/A errors only, it returns a specific value if the formula returns a #N/A error. Formula […]