What is EXCEL ISEVEN FUNCTION
The Excel ISEVEN Function is listed under Microsoft Excel's Information Functions category. It returns TRUE is the supplied value is an EVEN number. In simple words, with ISEVEN you can check that value is an even number or not.
How to use it
To learn how to use the ISEVEN function in Excel, you need to understand its syntax and arguments:
- number: The value that you want to evaluate.
- You can also insert a number into function directly by using double quotes or even without it.
- If you specify a non-numeric value it will return the #VALUE! error value.
To master the ISEVEN function we need to try it out in an example, so make sure to check out the below one:
Below we have used different arguments:
- It returns TRUE if the given number is even.
- It evaluates negative values in the same way.
- It treats 0 as an even number.
- If you specify a number with decimal points it ignores decimals and evaluates the integer. In this example, it has truncate .5 and evaluated 2.
- As Excel stores date as a serial number, it evaluates them in the same manner.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL CELL Function
- EXCEL ERROR.TYPE Function
- EXCEL INFO Function
- EXCEL ISBLANK Function
- EXCEL ISERR Function
- EXCEL ISERROR Function
- EXCEL ISFORMULA Function
- EXCEL ISLOGICAL Function
- EXCEL ISNA Function
- EXCEL ISNONTEXT Function
- EXCEL ISNUMBER Function
- EXCEL ISODD Function
- EXCEL ISREF Function
- EXCEL ISTEXT Function
- EXCEL N Function
- EXCEL NA Function
- EXCEL SHEET Function
- EXCEL SHEETS Function
- EXCEL TYPE Function
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.