Article updated on March 16, 2018

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

Formula in cell B3:


Excel Function Syntax



The NA() function has no arguments.


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) [~ez_hellip~]

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 [~ez_hellip~]