Returns the "value not available" error, '#N/A'.
Sample Usage
NA()
Syntax
NA()
The function syntax has no arguments.
Examples
NA() returns '#N/A' in the cell.
Notes
- Typing =NA() into a cell is equivalent to directly entering the error value '#N/A' in the cell.
- '#N/A' errors indicate missing information and are intended for functions to stop calculation. For example, if C4 contains the value '#N/A' , the formula C4+C5 will evaluate to '#N/A'.