Author: Oscar Cronquist Article last updated on May 04, 2022

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.

Recommended articles

How to use the ISNA function
The ISNA function returns TRUE if the returned value is a #N/A error. Table of Contents ISNA function Syntax ISNA […]

Recommended articles

How to use the IFNA function
The IFNA function handles #N/A errors only, it returns a given value you specify if the formula returns a #N/A […]