Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

ISEVEN

Check a cell for even number in Excel
Returns TRUE if the number is even

Rational

Check a cell for even number

Description

The Excel ISEVEN function check if a specified cell has even numeric value and returns “TRUE” when a cell has an even numeric value, and “FALSE” for an odd number.

Syntax

=ISEVEN(value)

Parameters

value – Refer cell to check numerical value (Odd or Even)

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISEVEN formula returns TRUE only if the value in the cell is an even number and FALSE for an odd number. The function will also return FALSE if an odd numerical value is in a text format.
  • The formula returns TRUE with a number, currency, date, and another number formatting. Must not include text formatting in the cell.
  • The ISEVEN formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.
 If a user wish to find a decimal number (3.4) is even or odd for this we apply formula =ISEVEN(“3.4”) it return FALSE as it check number before decimal point if number is even it return TRUE otherwise FALSE.

Keep Reading Similar Functions:

Converts data into a code number in Excel

N

The N function returns a code number by converting specific reference based on a set of rule. I.e., =N(B6) will return 43093, B6 refers to ’24-12-2017′.

Read More »
Check a cell for the numerical value in Excel

ISNUMBER

The ISNUMBER function checks if a specified cell has a numeric value and returns “TRUE” if a cell has a numeric value, and “FALSE” when a cell does not.

Read More »
Check a cell for odd or even numerical value in Excel

ISODD

The ISODD function checks if a specified cell has an odd numeric value and returns “TRUE” when a cell has an odd numeric value and “FALSE” for an even number.

Read More »