# Learn How to Use Microsoft Excel NA Function

Written by | 0 Comments | 637 Views

In this article, you will learn how to use the Microsoft Excel NA function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel NA function return value and syntax with the help of some examples.

Microsoft Excel NA Function

The main use of the Microsoft Excel NA Function is to create an #N/A error. The #N/A implies "not available" or "no value available". You can able to nest the NA function inside a formula to display an #N/A error when the information is missing.

Return Value of NA Function

The return value will #N/A error code.

Syntax of NA Function

=N( )

Where the arguments:

• value: It is the value to convert in a number.

## How to Use Microsoft Excel NA Function?

The main use of the Microsoft Excel NA Function is to create an #N/A error. The #N/A implies "not available" or "no value available". You can able to nest the NA function inside a formula to display an #N/A error when the information is missing.

It should be noted that:

• When other formulas refer to the cells that contain #N/A, they also return #N/A.
• You can also able to enter the value #N/A directly into the cell as text.
• The NA function takes no arguments, but you should provide blank parenthesis.

|