Skip to main content

ISNONTEXT

Definition of ISNONTEXT

Checks whether a value is non-textual.

Sample Usage

ISNONTEXT(A2)

ISNONTEXT("cat")

Syntax

ISNONTEXT(value)

  • value - The text to be checked.

    • ISNONTEXT returns FALSE if this is a text value or a reference to a cell containing a text value and TRUE otherwise.

    • When value is a reference to an empty cell, ISNONTEXT will return TRUE.

    • When value is an empty string, ISNONTEXT will return FALSE, as the empty string is considered text.

Notes

  • Nonprinting characters and whitespace count as text, so when ISNONTEXT is called on a cell containing such characters, the function will return FALSE even though the cell appears empty.

  • Numbers input as text, e.g. "1234" count as text, and will cause ISNONTEXT to return FALSE.

  • ISNONTEXT(value) is the logical equivalent of NOT(ISTEXT(value))

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

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.

ISERROR: Checks whether a value is an error.

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 ISNONTEXT formula, start with your edited Excellentable

 

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

 

Type in the complete ISNONTEXT 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)
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
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

JavaScript errors detected

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

If this problem persists, please contact our support.