NA

Excel Functions

Create an #N/A error

Return Value

The #N/A error

Details

The NA function returns the #N/A error. #N/A means "not available" or "no value available". You can use the NA function to display the #N/A error when information is missing. Note that if you use the NA function this way, other formulas that depend on cells that contain the #N/A error will also display #N/A, unless you specifically trap and manage the error. The NA function takes no arguments. The NA function returns the #N/A error: You can use the NA function in other formulas. For example, in the formula below, the IF function is configured to test if cell A1 is empty. If so, IF returns NA(), which returns the #N/A error. If A1 is not empty, IF returns A1*B1: You can use the NA function to indicate missing information. In the worksheet shown above, cells C9 and C13 contain the NA functio

Examples

The NA function returns the #N/A error:

EXCEL

=NA() // returns #N/A

Examples

You can use the NA function in other formulas. For example, in the formula below, the IF function is configured to test if cell A1 is empty. If so, IF

EXCEL

=IF(A1="",NA(),A1*B1) // #N/A if A1 is empty

Examples

You can use the NA function to indicate missing information. In the worksheet shown above, cells C9 and C13 contain the NA function:

EXCEL

=NA()

Examples

This indicates that cost is not available. In cell D5, the formula copied down is:

EXCEL

=B5*C5 // qty * cost

Examples

In cells D9 and D13, the formula returns #N/A because C9 and C13 contain errors. In cell D15 the SUMIF function is used to sum values in column D whil

EXCEL

=SUMIF(D5:D13,"<>#N/A") // ignore #N/A

Examples

If the SUM function was used instead, it would return #N/A:

EXCEL

=SUM(D5:D13) // would return #N/A

NA

Return Value

Details

Examples

See Also