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.

See Also

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`.

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

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

Type in the complete ISERROR 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		#VALUE!
16
17		TRUE

	D	E	F
1

House seat(s)

Error Type

50,645 (131,170)

1,775 (4,597)

7

570,641 (1,477,950)

94,743 (245,383)

1

113,594 (294,207)

396 (1,026)

9

52,035 (134,770)

1,143 (2,960)

4

155,779 (403,466)

7,916 (20,502)

53

103,642 (268,432)

452 (1,171)

7

4,842 (12,541)

701 (1,816)

5

1,949 (5,048)

540 (1,399)

1

53,625 (138,888)

12,133 (31,424)

27

57,513 (148,958)

1,912 (4,950)

14

6,423 (16,635)

4,509 (11,678)

2

82,643 (214,044)

926 (2,398)

2

#NULL!

#DIV/0!

#VALUE!

#REF!

#NAME?

#NUM!

#N/A

#GETTING_DATA

Anything Else

#DIV/0!

#NULL!

#DEV!