Related Topics:

Spreadsheet Mathematical Functions

Data Entry Tips for Functions

NA

Description: Returns the error value associated with #N/A. #N/A is the error value that means “no value is available.” Use NA to mark empty cells. By entering #N/A in cells where you are missing information, you can avoid the problem of unintentionally including empty cells in your calculations. (When a formula refers to a cell containing #N/A, the formula returns the #N/A error value.)

Syntax: NA( )

Remarks:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.