Excel ISEVEN Function

HomeExcel FunctionsExcel ISEVEN Function (Example + Sample File)

What is EXCEL ISEVEN FUNCTION

The Excel ISEVEN Function is listed under Microsoft Excel's Information Functions category. It returns TRUE is the supplied value is an EVEN number. In simple words, with ISEVEN you can check that value is an even number or not.

How to use it

To learn how to use the ISEVEN function in Excel, you need to understand its syntax and arguments:

Syntax

ISEVEN(number)

Arguments

  • number: The value that you want to evaluate.

Notes

  • You can also insert a number into function directly by using double quotes or even without it.
  • If you specify a non-numeric value it will return the #VALUE! error value.

Example

To master the ISEVEN function we need to try it out in an example, so make sure to check out the below one:

Below we have used different arguments:

  • It returns TRUE if the given number is even.
  • It evaluates negative values in the same way.
  • It treats 0 as an even number.
  • If you specify a number with decimal points it ignores decimals and evaluates the integer. In this example, it has truncate .5 and evaluated 2.
  • As Excel stores date as a serial number, it evaluates them in the same manner.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.