NA Formula in Excel

 

What Does It Do ?

This function is a place marker used to indicate that required information is Not Available.

It can be type directly in to a cell as =NA() or it can be used as part of a calculation.

When the =NA() is used, any calculations which depend upon the cell will also show #NA.

It is used to indicate that all the data has not yet been entered in to the spreadsheet.

image

Syntax

=NA()

Formatting

No special formatting is required.

No comments:

Post a Comment