Home Computer Learn NA(Not Available) Excel Formula

Learn NA(Not Available) Excel Formula

1 min read
1ST.0 1


Learn NA Excel formula (Not Available)

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.


No special formatting is required.

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.

NA Excel Formula example 1
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.
NA Excel formula Example2
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…