Skip to main content

ISODD

Definition of ISODD

Checks whether the provided value is odd.

Sample Usage

ISODD(4)

ISODD(A2)

Syntax

ISODD(value)

  • value - The value to be verified as odd.

    • ISODD returns TRUE if value is an odd integer or a reference to a cell containing an odd integer, and FALSE otherwise.

Notes

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

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.

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

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

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

Excellentable will generate the outcome when hitting enter. 

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

JavaScript errors detected

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

If this problem persists, please contact our support.