NA
Returns the #N/A error value, indicating data is not available.
NA()=NA()Returns not available error
=IF(A1="",NA(),A1)Mark empty as not available
=IFERROR(B1/A1,NA())Replace errors with #N/A
- •Used to mark missing data intentionally
- •Charts skip #N/A values
- •Different from empty cells
- •Confusing NA() with ISNA - NA() deliberately generates the #N/A error, while ISNA checks whether a value already is that error
- •Using NA() as a permanent placeholder in a shared workbook without documenting why, which can confuse other users into thinking something is broken rather than intentionally left blank
- •Forgetting that NA() propagates through most formulas that reference it, so a single NA() cell can cause errors to cascade through dependent calculations across the sheet
ISNAChecks whether a value is the #N/A error, often used to detect and handle the error NA() deliberately creates.IFNASubstitutes a fallback value specifically for #N/A errors, useful for controlling what happens downstream of a cell containing NA().IFERRORSubstitutes a fallback for any error type, a broader tool than IFNA for handling cells that might contain NA() or other errors.What does NA() actually do?
It deliberately inserts the #N/A error into a cell - useful as a placeholder for missing data that you want to flag clearly, for example in charts where #N/A points are skipped rather than plotted as zero.
Why does an error appear in a formula referencing a cell with NA()?
#N/A propagates through most calculations, so any formula referencing a cell containing NA() will typically also return #N/A unless it's specifically wrapped in IFNA or IFERROR.
How is NA() different from leaving a cell blank?
A blank cell is usually treated as 0 in calculations, while NA() explicitly flags the value as missing or not available, which some charts and formulas handle differently.
Need to translate a formula using NA?
Use our translator to convert your complete formula