Skip to main content

TYPE

Definition of TYPE

Returns a number associated with the type of data passed into the function.

Sample Usage

TYPE(C4)

TYPE({1;2;3;4;5})

Syntax

TYPE(value)

  • value - The data whose type is to be determined.

Notes

  • This function returns the following numbers:
    • 1: if value is a number
    • 2: if value is text
    • 4: if value is boolean
    • 16: if value is an error
    • 64: if value is an array
    • 128: for any other type of cell. For example, in-cell images and sparklines.
  • The function cannot determine whether or not a cell or range of cells is using a formula, only returning the type of value being displayed in the cells.

See Also

ISTEXT: Checks whether a value is text.

ISNUMBER: Checks whether a value is a number.

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

ISERROR: Checks whether a value is an error.

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

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

Type in the complete TYPE 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
2
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

JavaScript errors detected

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

If this problem persists, please contact our support.