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.

EVEN,ODD,ISEVEN,ISODD Functions in Excel

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

EVEN,ODD,ISEVEN,ISODD Functions in Excel

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.

EVEN,ODD,ISEVEN,ISODD Functions in Excel
EVEN,ODD,ISEVEN,ISODD Functions in Excel

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)

EVEN,ODD,ISEVEN,ISODD Functions in Excel

ISODD

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

Syntax – ISODD(number)

EVEN,ODD,ISEVEN,ISODD Functions in Excel

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
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