NA

  • Updated

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'.