Check a cell for even number
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.
value – Refer cell to check numerical value (Odd or Even)
A Boolean value (TRUE or FALSE)
- 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.