Menu
EXCEL NA FUNCTION
Excel NA Function Introduction
The Excel NA function returns the #N/A error code. This error notice, which means ‘value not accessible,’ is generated when an Excel Formula is unable to discover a value that it requires.
Description of Excel NA Function
Syntax :
=NA()
Parameters :
- You may also get the same result by just putting #N/A into a worksheet cell.
Step By Step Guide of NA Function
Example :
The Example of NA Function.
Key Points
- The function name must be surrounded by empty parenthesis. Otherwise, it will not be recognised as a function by Microsoft Excel.
- You may also simply enter the value #N/A into a cell. For interoperability with other spreadsheet applications, the NA function is offered.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
