How to use NA Function in Excel

how to use excel na function

Quick Intro

Use Excel NA Function to generate a #N/A error value. Best use of NA function in excel to get an error when you have empty and missing information in a cell.


NA( )

  • There is no argument in NA Function but you have to enter empty parentheses.

More Information on Excel NA Function

  • You can also type #N/A directly into a cell.
  • NA Function is mainly provided for compatibility with other spreadsheet programs.

What’s Next?

To learn more about Excel NA Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have IFNA function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.