Home › Functions › Information › =NA()
Information All versions ◉ 5 views

=NA()

Deliberately places the #N/A error in a cell to indicate that the value is not available

=NA()
Hover argument names in the table for details.
Output typeError
Popularity15 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =NA() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download NA.xlsx — Coming soon ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

No arguments.

▣ Examples

Example 1 =NA()
Example 2 =IF(B2 = 0, NA(), A2 / B2)

✦ Tips

  • Empty parentheses must be included.
  • Any formula that refers to this cell also becomes #N/A.
  • Use ISNA to detect this error and IFNA to replace it.

⇄ Related Functions

=IF() Decision structure, checking condition(s) and specifying alternative outcomes =IFNA() Replaces the #N/A error with another value =ISNA() Whether it is the #N/A error or not

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.