Skip to content

na

Return the #N/A error value.

v = na

Returns the #N/A (not available) error value. Used to mark cells as having missing data — chart series, conditional logic, and many statistical functions skip #N/A cells.

na() % #N/A
  • isna — Test whether a value is #N/A.
  • iserror — Test whether a value is any error.