Skip to main content

NA

Definition of NA

Returns the "value not available" error, `#N/A`.

Sample Usage

NA()

Syntax

NA()

Notes

  • #N/A is an error, so both the ISNA and ISERROR functions will return TRUE. Use ISERR to find errors which are not #N/A.

  • Typing =NA() into a cell is equivalent to directly entering the error value #N/A.

  • #N/A is used to mark missing information and to indicate to functions operating on ranges or cells containing such values to halt calculation. For instance, if cell B2 contained the result of an IF statement:=IF(ISBLANK(A1),0,A1) and B2 was subsequently involved in a sum or other formula, that formula would assume that B2 held the correct information. By altering the formula in B2 to=IF(ISBLANK(A1),NA(),A1), any subsequent operation on B2 would halt upon encountering the #N/A error, and return that error.

  • #N/A errors indicate missing information and signal functions using to cease calculation. Use the #N/A value instead of 0 or

    results. For example, if A1 contains the value #N/A or =NA(), the formula =A1+A2 will evaluate to #N/A.

See Also

ISNA: Checks whether a value is the error `#N/A`.

ISERROR: Checks whether a value is an error.

ISERR: Checks whether a value is an error other than `#N/A`.

In order to use the NA formula, start with your edited Excellentable

 

Then type in the NA Formula in the area you would like to display the outcome:

 

Type in the complete NA formula for a cell as shown below:

 

Excellentable will generate the outcome when hitting enter. 

A
B
C
1
State
Population
Total area in mi2
Land area in mi2
Water area in mi2
2
Alabama
4833722
52,420 (135,767)
3
Alaska
735132
665,384 (1,723,337)
4
Arizona
6626624
113,990 (295,233)
5
Arkansas
2959373
53,179 (137,733)
6
California
38332521
163,695 (423,968)
7
Colorado
5268367
104,094 (269,602)
8
Connecticut
3596080
5,543 (14,356)
9
Delaware
925749
2,489 (6,446)
10
Florida
19552860
65,758 (170,312)
11
Georgia
9992167
59,425 (153,910)
12
Hawaii
1404054
10,932 (28,314)
13
Idaho
1612136
83,569 (216,443)
14
15
#N/A
D
E
F
1
House seat(s)
2
50,645 (131,170)
1,775 (4,597)
7
3
570,641 (1,477,950)
94,743 (245,383)
1
4
113,594 (294,207)
396 (1,026)
9
5
52,035 (134,770)
1,143 (2,960)
4
6
155,779 (403,466)
7,916 (20,502)
53
7
103,642 (268,432)
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
540 (1,399)
1
10
53,625 (138,888)
12,133 (31,424)
27
11
57,513 (148,958)
1,912 (4,950)
14
12
6,423 (16,635)
4,509 (11,678)
2
13
82,643 (214,044)
926 (2,398)
2
14
15
G
1
2
TRUE
3
TRUE
4
TRUE
5
FALSE
6
TRUE
7
FALSE
8
TRUE
9
FALSE
10
TRUE
11
FALSE
12
TRUE
13
FALSE
14
15

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.