NA
Returns the #N/A (Not Available) error value.
Syntax:
NA()
This function has no arguments, and returns the error value #N/A.
Example:
NA()
returns #N/A.
Application:
Sales Data Analysis
Imagine you are a data analyst for a retail company and you are tracking monthly sales data for different product lines. For some products, you don't have sales data for a particular month, perhaps because the product was discontinued or was not yet launched.
Using the NA() function allows you to clearly mark these gaps in your data.
Scenario
You have the following sales data in a spreadsheet. The goal is to calculate the average sales for each product line.
Product Line | Jan 2025 Sales | Feb 2025 Sales | Mar 2025 Sales | Apr 2025 Sales | May 2025 Sales | ||
|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | ||
1 | Electronics | $15,000.00 | $18,500.00 | $16,000.00 | $19,200.00 | $20,000.00 | |
2 | Apparel | $8,000.00 | $9,500.00 | $11,000.00 | $10,500.00 | #N/A | |
3 | Home Goods | #N/A | $7,200.00 | $8,500.00 | $9,100.00 | $9,800.00 | |
4 | Sports | $6,500.00 | $7,000.00 | #N/A | $7,500.00 | $8,200.00 |
- For the "Apparel" product line, you don't have the May 2025 sales data because that product line was discontinued in late April.
- For the "Home Goods" product line, you don't have the January 2025 sales data because the product line was launched in February.
- For the "Sports" product line, the data for March is missing due to a reporting error.
Why use NA()?
- Clarity: The #N/A error clearly signals that the data is not available. If you left the cell blank, other users might think the value is zero, or they might not know if the data is just missing or if the cell was forgotten.
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof