HomeMicrosoft OfficeExcelEVEN,ODD,ISEVEN,ISODD Functions in Excel

EVEN,ODD,ISEVEN,ISODD Functions in Excel

Here youâ€™ll get to know about few functions in Excel thatâ€™ll help you round off numbers and determine whether the given number is odd or even.

EVEN, ODD are functions that help you in rounding off of numbers.

ISEVEN and ISODD are the functions that determine whether the number is odd or even.

EVEN

This function rounds off the given number to the nearest even number.

Syntax â€“ EVEN(number)

The number mentioned is here the number to be rounded off.

If the given number is positive then the function rounds up to the nearest even positive number.

If the given number is negative then it rounds down to the nearest even negative number.

ODD

This function rounds off the given number to the nearest odd number.

Syntax â€“ ODD(number)

If the given number is positive then it rounds up to the nearest odd positive number and if the number is negative it rounds down to the nearest odd negative number.

ISEVEN

This function returns TRUE or FALSE.

When you enter the function, if the given number is even it displays TRUE if not FALSE.

Syntax â€“ ISEVEN(number)

ISODD

This function returns TRUE if the given number is odd and FALSE if not odd.

Syntax â€“ ISODD(number)

You May Also Like

SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021