How to Determine If a Number is Even or Odd

What are Odd and Even Numbers?

Even numbers definition

Even numbers are numbers that are always divisible by 2. No reminder always returns integer number.

Odd numbers definition

Odd numbers are numbers that are not multiples of 2. If divided by the number two, always there is a fraction in the result.

Is Zero an Even Number?

If you divide 0 by number 2, the result is always 0 and is corresponding to the definition of an even number, no remainder if divided by the number 2. So, zero is an even number.

Solution Using MOD Function

You can use the MOD function to determine an odd or even number by utilizing even number characteristics, which are always divisible by the number 2.

The MOD function is used to find out if there is a remainder after the division operation. If a number is divided by 2 and there is no remainder, then that is an even number.

Please See the image below for the results of the MOD function with divisor argument 2

The Formula

=MOD(A2,2)

The MOD function returns 0 is an even number, and the one returns 1 is an odd number.

For the more informative result, please add the IF function.

The Formula

=IF(MOD(A2,2)=0,"Even","Odd")

Solution Using ISODD Function

The ISODD function is a special function made by Excel to check whether a number is an odd number or not. Only has one argument, which is the number to be checked.

If the ISODD function returns TRUE, then the checked number is odd, otherwise is even.

The result is as shown below

The Formula

=ISODD(A2)

Please add the IF function for more informative results

The Formula

=IF(ISODD(A2),"Odd","Even")

Solution Using ISEVEN Function

The ISEVEN function is the opposite of the ISODD function, returns TRUE if the number is even and false if the number is odd.

The result is as shown below

The Formula

=ISEVEN(A2)

Please add the IF function for more informative results

The Formula

=IF(ISEVEN(A2),"Even","Odd")

Which One is the Best?

Excel provides three functions to check whether a number is odd/even. Nothing stands out among the three.

You can choose any function to check whether a number is odd/even.

Related Function