Learn How to Use Microsoft Excel NA Function

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.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel