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.
Syntax
=NA()
Formatting
No special formatting is required.
Example
The following table was used by a
company to calculate the monthly Wage of an employee.
The Salary and Tax percentage are
entered.
The Tax is then deducted from the
Salary to calculate the Wage.
Table 1 shows that when the Tax is
not entered, the Wage is still calculated.
On a large spreadsheet this may go
unnoticed and the wrong Wage paid.
Table
2 shows how the =NA() has been inserted in the unknown Tax to act as a reminder
that the Tax still needs to be entered.
No comments:
Post a Comment