Quick Navigation

NA Function

Excel 2007+

Summary

The NA function in Excel intentionally returns the #N/A error value, signaling that no data is available for that cell. This is essential for marking missing information in datasets, ensuring calculations properly handle data gaps without treating them as zeros or blanks.

Syntax

NA()

Using the NA Function

Use NA() to explicitly indicate missing or unavailable data in your spreadsheets. This prevents formulas from incorrectly processing empty cells as zero values and ensures error-handling functions like IFNA or IFERROR work correctly when data lookup operations return no results.

Common NA Examples

Basic NA Usage

=NA()

Enters #N/A error value directly into the cell to mark missing data.

Using NA in Data Tables

=IF(B2="",NA(),B2*1.1)

Returns NA() when B2 is empty, otherwise multiplies by 1.1.

Marking Incomplete Datasets

=IF(C2="N/A",NA(),AVERAGE(B2:B10))

Converts text 'N/A' to actual #N/A error value for proper formula handling.

Frequently Asked Questions

Yes, you must use NA() with empty parentheses. Excel won't recognize NA without them as the function.

Yes, you can type #N/A directly, but NA() ensures compatibility with other programs and formulas.

Blank cells are treated as zero in many calculations. NA() properly propagates the 'no data available' condition.

Common Errors and Solutions

Excel doesn't recognize NA as a function

Cause: Missing the required empty parentheses

Solution: Always use NA() with parentheses, even though no arguments are needed

#NAME? error when typing NA

Cause: Typed NA without parentheses

Solution: Enter =NA() instead of just NA

Notes

#N/A propagates through formulas - if any referenced cell contains #N/A, the formula returns #N/A
Use IFNA() to handle #N/A specifically without affecting other error types
Essential for VLOOKUP, XLOOKUP, and INDEX/MATCH when no matching data is found
Available in all Excel versions since 2007

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365, Excel Online

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+