# ISERROR

### Definition of ISERROR

Checks whether a value is an error.

### Sample Usage

`ISERROR(A2)`

`ISERROR(A1/A2)`

`IF(ISERROR(VLOOKUP(B1, A1:A100, 1, FALSE)), "Result not found", VLOOKUP(B1, A1:A100, 1, FALSE))`

### Syntax

`ISERROR(value)`

• `value` - The value to be verified as an error type.

• `ISERROR` returns `TRUE` if `value` is any error, including `#DIV/0!``#N/A``#NAME?`,`#NULL!``#NUM!``#VALUE!`, and `#REF!`.

### Notes

• `ISERROR` returns `TRUE` on any error, unlike `ISERR`, which returns `TRUE` on all errors except for `#N/A`. Ensure that the correct call is used.

• This function is most often used in conjunction with `IF` in conditional statements.

`ISTEXT`: Checks whether a value is text.

`ISREF`: Checks whether a value is a valid cell reference.

`ISODD`: Checks whether the provided value is odd.

`ISNUMBER`: Checks whether a value is a number.

`ISNONTEXT`: Checks whether a value is non-textual.

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

`ISLOGICAL`: Checks whether a value is `TRUE` or `FALSE`.

`ISEVEN`: Checks whether the provided value is even.

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

`ISBLANK`: Checks whether the referenced cell is empty.

`IF`: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

### 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
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
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
#VALUE!
16
17
TRUE
D
E
F
1
House seat(s)
Error Type
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
16
17
G
1
2
#NULL!
3
#DIV/0!
4
#VALUE!
5
#REF!
6
#NAME?
7
#NUM!
8
#N/A
9
#GETTING_DATA
10
Anything Else
11
#DIV/0!
12
#NULL!
13
#DEV!
14
15
16
17

JavaScript errors detected