Excel NA Function

This post will guide you how to use Excel NA function with syntax and examples in Microsoft excel.

Description

The Excel NA function returns the #N/A error value. And the #N/A is the error value that means “no values is available”. And the #N/A error value will be produced when a formula is not able to find a valid value.

The NA function is a build-in function in Microsoft Excel and it is categorized as an Information Function.

The NA function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the NA function is as below:

= NA ( )

There are no parameters or arguments for the NA function.

Note:

  • You must include the empty parentheses with the function name. Otherwise, Microsoft Excel will not recognize it as a function.
  • You can also type the value #N/A directly into a cell. The NA function is provided for compatibility with other spreadsheet programs.
Related Posts

VLOOKUP Formula | Faster Trick with 2 VLOOKUPS

This post will guide you how to use 2 VLOOKUPS function to looking up data entries from a given range of cells in Microsoft Excel. VLOOKUP with 2 lookups can be faster than a single VLOOKUP in certain scenarios. The ...

Excel DSUM Function

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you ...

Excel DSTDEVP Function

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or ...

Excel DSTDEV Function

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database ...

Excel DMIN Function

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar