ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel ISEVEN Function

Excel ISEVEN Function

How to Use Excel ISEVEN Function
Table of contents :
  • What is the Excel ISEVEN Function?
  • ISEVEN Syntax
  • How to Use ISEVEN Function in Excel
  • ISEVEN Example

Excel ISEVEN Function

What is the Excel ISEVEN Function?

Even numbers are an integer number “evenly divisible” by 2; there is no remainder. Excel provides a function to check whether a number is even or not with the ISEVEN function without having to know if there is any remainder. Returns TRUE if the even number and FALSE if not.

ISEVEN Syntax

ISEVEN(number)

number, required, the numeric value to test

Usage Note:

  • Returns a #VALUE! error if non-numeric fills the number argument
  • All decimal fractions truncated to an integer number

How to Use ISEVEN Function in Excel

For example, there is data like the image below. What is the result of the ISEVEN function in column B?

Excel ISEVEN Function

ISEVEN Function #1

=ISEVEN(A1)

The result is TRUE. Zero is an even number, has no remainder if divided by the number 2

ISEVEN Function #2

=ISEVEN(A2)

The result is FALSE. Excel stores date in the form of integer numbers, 1 represents January 1, 1900, 2 represents January 2, 1900, and so on.

January 1, 1900, is equal to 1, an odd number.

Please read the article below for a detailed explanation of how dates and times stored in Excel

  • How does Excel Store Dates and Times?

ISEVEN Function #3

=ISEVEN(A3)

The result is #VALUE! error. TRUE is a logical value, not a number.

ISEVEN Function #4

=ISEVEN(A4)

The result is FALSE. 3 is an odd number, positive or negative.

ISEVEN Function #5

=ISEVEN(A5)

The result is TRUE. 4.50E+06 is 4,500,000, only need to see the last digit of a number to determine odd/even. Zero is an even number.

ISEVEN Function #6

=ISEVEN(A6)

The result is FALSE. 5 is an odd number, if divided by 2 has a remaining number.

Please see the image below for the results of the six functions above

How to Use ISEVEN Function in Excel

ISEVEN Example

Another article using or explain about ISEVEN Function
  • How to Determine If a Number is Even or Odd

Another Information Function

Another article about Information Function
  • Excel ISEVEN Function
  • Excel ISODD Function
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Excel NUMBERVALUE Function
What is the Excel NUMBERVALUE Function? Excel NUMBERVALUE function converts …

Excel NUMBERVALUE Function

Excel Weekday Function
What is the Excel WEEKDAY Function? Excel WEEKDAY function returns …

Excel WEEKDAY Function

Excel AVERAGEIF Function
What is the Excel AVERAGEIF Function? The Excel AVERAGEIF function …

Excel AVERAGEIF Function

Excel AVERAGEIFS Function
What is the Excel AVERAGEIFS Function? The Excel AVERAGEIFS function …

Excel AVERAGEIFS Function

Excel MATCH Function
What is the Excel MATCH Function? Excel MATCH function returns …

Excel MATCH Function

Tags:Information Function

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh