< Go Back

Excel NA Function

The NA function is a function in Excel grouped under Information function. This function is a worksheet function (WS) which means it can be fixed into a formula in a cell of a worksheet.

What is the Excel NA Function?

The NA function in Excel generates the #N/A error value. #N/A stands for “Not available”. The NA is used to identify empty cells or any problem which may arise in the calculation.

Formula or Syntax

=NA()

Arguments or Parameters of the NA Function

The Excel NA function syntax has no parameters or arguments.

How to use the NA Function in Excel?

The NA function is used to generate the #N/A. Let’s consider the example for better understanding of how to use the NA function in Excel.

Example 1

  • Let’s use the NA function directly in a cell of a worksheet.

Figure 1. The Excel NA function applied directly in a cell.

  • The result displayed shows that the #N/A error value is generated by the NA function.

Figure 2. The #N/A error value is generated by the Excel NA function.

Example 2

  • Consider a sales table that shows the quantity and the price of different items bought.

Figure 3. A sales table used to illustrate the use of the NA function.

  • Let’s apply the formula which contains the NA function and the IF function, which gives conditions.

Figure 4. The NA function is used within a formula.

  • The #N/A error value is generated by the NA function because there is an empty quantity in the 6th row.

Figure 5. The #N/A error value is generated by the Excel NA function.

Notes

  • The function name must be used with the empty parentheses, that is, NA().
  • #N/A error can be entered directly into cells as text.
  • Formulas that refer to a cell containing #N/A error can also return the #N/A error value.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar