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:

=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 the returned value is a #N/A error. Table of Contents ISNA function Syntax ISNA […]

How to use the ISNA function

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 […]

How to use the IFNA function