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 INT Function
What is the Excel INT Function? The excel INT function …

Excel INT Function

Excel LEN Function
What is the Excel LEN Function? The excel LEN function …

Excel LEN Function

Multiple IF Statements in Excel
What is Multiple IF Statements? Multiple IF statements are also …

Multiple IF Statements in Excel

INDEX MATCH Excel
INDEX MATCH Formula You can use the INDEX function and …

INDEX MATCH – Excel VLOOKUP Alternative

Excel LEFT Function
What is the Excel LEFT Function? The excel LEFT function …

Excel LEFT 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 © 2022 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