ISEVEN function - Function returns True value if the value is even in Excel

ISEVEN function: The function returns True if the value is even in Excel. Syntax: ISEVEN (value)

The following article introduces you to the ISEVEN function - one of the functions in the information function group is very popular in Excel.

Picture 1 of ISEVEN function - Function returns True value if the value is even in Excel

Description: The function returns True if the value is even in Excel.

Syntax: ISEVEN (value)

Inside:

- value: The value you want to determine is even or not, is a required parameter.

Attention:

- The function returns True if the value is even and vice versa if an odd number the function returns False.

- If Value is not a numeric value -> the function returns the #VALUE! Error value

- If value value is blank -> the function considers that value as 0.

For example:

Determine whether the values in the value are even.

Picture 2 of ISEVEN function - Function returns True value if the value is even in Excel

- In the cell to calculate enter the formula : = ISEVEN (C6)

Picture 3 of ISEVEN function - Function returns True value if the value is even in Excel

- Press Enter -> return value is:

Picture 4 of ISEVEN function - Function returns True value if the value is even in Excel

- Where value is blank -> the function considers it as a value of 0:

Picture 5 of ISEVEN function - Function returns True value if the value is even in Excel

- Where the value is not numeric -> the function returns the error value #VALUE!

Picture 6 of ISEVEN function - Function returns True value if the value is even in Excel

Above are instructions and some specific examples when using ISEVEN function in Excel.

Good luck!

Update 19 May 2020

You should read it