< Go Back

Excel ISEVEN Function

Excel ISEVEN function

As the name suggests,  the Excel ISEVEN function is a built-in function of the Excel which determines whether a given numeric value is even or not. This function returns a logical TRUE for even numbers and FALSE for the odd ones.

Syntax

=ISEVEN(value)

Argument

value – This includes (or)contains the numeric value to be checked.

How does the function work?

  1. The Excel ISEVEN  function checks the value parameter which contains s a numeric value.
  2. This function then returns a TRUE (or) FALSE depending, if the value is even or an odd TRUE value returned indicates an even value and a FALSE value returned indicates an odd numeric value. Also, note that if the non_numeric value is entered as a value parameter then Excel ISEVEN function returns the #VALUE! Error.
  3. For example, =ISEVEN(C1)  ,say cell C1 contains a numeric value. This will return a TRUE if C1 contains an even number (2,4,6…) or returns a FALSE if C1 contains an odd number (1,3,5,7….).

Note on ISEVEN formula examples

The excel ISEVEN function, when combined with other built-in functions, can perform a different unique operation some of these includes.

  1. Shading(or) highlighting an alternate group of ‘n’ rows can be done when used with a ROW, CEILING  function.
  2. To highlight every other row in a list, when used with ISEVEN or ISODD functions.

Example

Let us consider a table with a list of random values and determine the even numbers by using the Excel ISEVEN function .the table is as shown below.

Figure 1. Shows the results for different numeric values using the Excel ISEVEN function

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar