How to use the ISODD function
What is the ISODD function?
The ISODD function returns TRUE if a cell contains an odd number, FALSE if even number. The ISODD and ISEVEN functions are different from the other IS functions, they return an error if the input value is an error. This is not the case with the other IS functions, they return TRUE or FALSE.
What is an odd number?
An odd number is an integer that is not evenly divisible by 2. Odd numbers have a remainder of 1 when divided by 2. For example: 5/2 = 2 with remainder 1. The set of odd natural numbers is {1, 3, 5, 7, 9...}. The opposite of an odd number is an even number.
What is an integer?
An integer is a whole number that can be positive, negative, or zero. Integers do not have decimal values. Examples of integers are -5, 12, 1, 15, 5005.
What is evenly divisible by 2?
A number that is evenly divisible by 2 can be divided by 2 without any remainder. The number divides perfectly into 2 equal parts. Examples of numbers evenly divisible by 2 are 12, 24, 800, 258. Even numbers are always evenly divisible by 2.
What is a remainder?
The remainder is what is left over after dividing two numbers. For example, 7 divided by 2 has a quotient of 3 and leaves a remainder of 1. 2*3 +1 = 7 When there is no number left over the remainder is 0. Evenly divisible numbers have a remainder of 0.
What is an even number?
An even number is perfectly divisible by 2. For example: 12/2 = 6 with remainder 0.
What is a natural number?
Natural numbers start from 1 and go on infinitely (1, 2, 3, 4, 5, 6, ...). They do not include negative integers or zero.
Other IS functions
Excel Function | Description |
---|---|
ISBLANK(value) | Returns TRUE if the value is empty, FALSE otherwise |
ISERR(value) | Returns TRUE if the value is any error value except #N/A, FALSE otherwise |
ISERROR(value) | Returns TRUE if the value is any error value, FALSE otherwise |
ISEVEN(value) | Returns TRUE if the value is an even number, FALSE for odd numbers |
ISFORMULA(reference) | Returns TRUE if the cell contains a formula, FALSE otherwise |
ISLOGICAL(value) | Returns TRUE if the value is a logical value (TRUE/FALSE), FALSE otherwise |
ISNA(value) | Returns TRUE if the value is the #N/A error, FALSE otherwise |
ISNONTEXT(value) | Returns TRUE if the value is not text, FALSE if it is text |
ISNUMBER(value) | Returns TRUE if the value is a number, FALSE otherwise |
ISODD(value) | Returns TRUE if the value is an odd number, FALSE for even numbers |
ISODD function Syntax
ISODD(number)
ISODD function Arguments
number | Required. The value you want to check for an odd number. |
The ISODD function is different from the other IS functions, it does not return FALSE for error values like #N/A, #REF, #VALUE etc.
ISODD function example
Formula in cell C6:
Functions in 'Information' category
The ISODD function function is one of 19 functions in the 'Information' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form