# Excel NA function

## Summary

The Excel NA function is designed to return the #N/A error, which stands for “Not Available.” This function is particularly useful for indicating missing or unavailable data in a dataset. Utilizing the NA function allows users to clearly differentiate between zeros, blank cells, and truly unavailable data, enhancing data integrity and analysis.
##### Syntax
```				```
=NA()
```
```
The NA function does not require any arguments.
##### Return value
The function returns the #N/A error value.

## How to use

NA is typically used in formulas to flag data points that are missing or should be excluded from calculations. It can be effectively combined with other functions like IF to handle conditions where data is unavailable, ensuring that your Excel models and analyses accurately reflect the state of your data.

## Examples

##### Simple NA
Direct Use to Indicate Missing Data: Inserting the NA function to explicitly mark a cell as having unavailable data.
```				```
=NA()

```
```
This formula can be entered into any cell to display the #N/A error, clearly indicating missing or unavailable information.
##### NA with IF Condition
Conditional Error Handling: Using NA in conjunction with the IF function to return an error for specific conditions.
```				```
=IF(A1="",NA(),A1*B1)

```
```
In this formula, if cell A1 is empty, IF returns #N/A by calling NA(); otherwise, it calculates the product of A1 and B1. This approach is useful for highlighting when an expected input is missing.
##### NA with SUMIF to Exclude Errors
Summing Data while Ignoring #N/A Errors: Employing SUMIF to aggregate values in a range, excluding cells with #N/A errors generated by the NA function.
```				```
=SUMIF(D5:D13,"<>#N/A")

```
```
This formula sums the values in the range D5:D13 but ignores any cells that contain #N/A errors, ensuring accurate summation without the interference of missing data points.