Excel NA Function

Excel NA Function

Summary 

The Excel NA function returns the #N/A error. #N/A means “not available” or “no value available”. 

Purpose 

Create an #N/A error

Return value 

The #N/A error

Syntax 

=NA ()

Arguments 

 

Usage notes 

Use NA to generate the #N/A. #N/A means “not available” or “no value available”. For example, you can use NA to flag cells that are empty or missing information.

When other formulas refer to cells that contain #N/A, the also return #N/A.

NA takes no arguments, but you must provide empty parentheses.

You can also enter the value #N/A directly into a cell.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo