Check Sheet Logo
Check Sheet

ISEVEN

The ISEVEN function in Google Sheets is used to check if a given number is even or not. It returns either `TRUE` if the number is even or `FALSE` if the number is odd. This function is most commonly used in combination with other functions to perform conditional logic.

Usage

Use the ISEVEN formula with the syntax shown below, it has 1 required parameter:

=ISEVEN(value)
Parameters:
  1. value (required):
    The number or reference to a cell containing the number to check for evenness.

Examples

Here are a few example use cases that explain how to use the ISEVEN formula in Google Sheets.

Conditional formatting

Use ISEVEN in combination with conditional formatting to highlight even or odd numbers in a range of cells.

Filtering

Use ISEVEN as part of a filter formula to extract only the even or odd numbers from a range of data.

Data validation

Use ISEVEN as part of a data validation formula to restrict users to entering only even or odd numbers in a cell.

Common Mistakes

ISEVEN not working? Here are some common mistakes people make when using the ISEVEN Google Sheets Formula:

Incorrect Argument Type

One common mistake is not providing a numeric value as the argument for the ISEVEN function. This will result in a #VALUE! error. To correct this mistake, make sure the argument is a numeric value.

Missing Argument

Another common mistake is forgetting to provide an argument for the ISEVEN function. This will result in a #VALUE! error. To correct this mistake, make sure to provide a valid argument for the function.

Incorrect Function Name

A possible mistake is misspelling the function name as 'ISEVAN' instead of 'ISEVEN'. This will result in an #NAME? error. To correct this mistake, double-check the spelling of the function name.

Related Formulas

The following functions are similar to ISEVEN or are often used with it in a formula:

  • ISODD

    The ISODD function is a Math formula that returns TRUE if the provided value is an odd number, and FALSE if it is an even number. This formula is commonly used when you need to check if a number is odd or even before performing certain operations on it.

  • EVEN

    The EVEN function rounds a given value up to the nearest even integer. This function is commonly used when dealing with financial data, as many financial calculations require the use of even numbers.

  • ODD

    The ODD function rounds up a given value to the nearest odd integer. It takes one required parameter, value, which is the number to be rounded up. This function is commonly used in scenarios where only odd values are acceptable, such as in lottery games and sports scoreboards.

  • MOD

    The MOD function returns the remainder of a division operation. It takes two numeric inputs: the dividend and divisor. The result will be the remainder after the dividend has been divided by the divisor. This function is often used in financial and accounting calculations.

  • ROUND

    The ROUND formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If the places parameter is not specified, the formula rounds to the nearest integer.

Learn More

You can learn more about the ISEVEN Google Sheets function on Google Support.