EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel EVEN Excel Function

EVEN Excel Function

By Jeevan A YJeevan A Y

EVEN Function in Excel

EVEN Function (Table of Contents)

  • EVEN Function in Excel
  • How to Use EVEN Function in Excel?

EVEN Function in Excel

EVEN Function converts any Odd number or any number into the nearest even number. The selected number can be a whole number or in decimal. The important thing is that if we feed an even number, it will not be changed, and it only considers numbers.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

EVEN Formula in Excel:

Below is the EVEN Formula in Excel :

EVEN Formula in excel

EVEN Formula includes only one argument.

  • Number: The required parameter converts the supplied number to the nearest even number.

How to Use EVEN Function in Excel?

This is very simple and easy to use. Let us understand the working of the EVEN Function in Excel with some examples.

You can download this EVEN Excel Function Template here – EVEN Excel Function Template

Example #1

In this example, Convert the below-given numbers to the nearest EVEN number. Enter these numbers from A2:A8 and

EVEN Function Example 1-1

And apply the even formula in cell B2.

EVEN Function Example 1-2

Now drag and drop the formula to the remaining cells.

EVEN Function Example 1-3

Now, look at each example one by one.

  • Firstly the value we are converting is 5.1, and the nearest EVEN integer value is 6. It cannot be 4 because the difference between 5.1 and 4 is (5.1 – 4 = 1.1) 1.1, but the difference between 5.1 and 6 is (5.1 – 6 = 0.9) 0.9. So the closest EVEN integer number is 6.
  • The same logic applies to the second one as well.
  • For the third value, a negative even number for -3.1 is 4. It is because the nearest integer EVEN number is 4, not 2.
  • The fourth one is -0.39; the first-ever EVEN number is -2. Therefore, the formula has returned -2 as a result.

Like this EVEN formula, round up the given number to the nearest EVEN number.

Example #2

In this example, Find all the EVEN numbers from the list below and count how many there are.

EVEN Example 2-1

We can find the total number of EVEN numbers using the EVEN and COUNTIF formulas.

Step 1: Check each number whether it is EVEN or ODD.

EVEN Function Example 2-2

Result is :

EVEN Function Example 2-2.1

If it is, the EVEN number shows as TRUE.

EVEN Function Example 2-3

If it is, the ODD number shows as FALSE.

EVEN Function Example 2-4

The formula checks whether the value in cell A2 equals the closest EVEN number. If it is equal, it will return TRUE; if not, it will return FALSE.

EVEN Example 2-5

Step 2: Apply the COUNTIF formula in cell D3 to get the total count of TRUE, representing EVEN numbers in the list.

EVEN Example 2-6

Here COUNTIF formula counts all the TRUE values in the range B2: B18 and returns the total count of all the TRUE values. The total number of TRUE values in B2: B18 is 9. That means there are 9 EVEN numbers are there in the list.

EVEN Example 2-7

Example #3

In this example, if the ticket number is an EVEN number below the passenger’s data, schedule them for a 10:00 PM flight. If the ticket number is an ODD, schedule them for the 11:00 PM flight.

EVEN Example 3-1

Now enter this data in Excel and follow the steps below to allocate a flight to 10:00 PM or 11:00 PM.

Check if the ticket number equals the EVEN number shown as “10:00 PM Flight” or “11:00 PM Flight”.

EVEN Function Example 3-2

Firstly, we check whether the ticket number equals an EVEN number using the logical function IF condition. If the first supplied condition is true, the result will be shown as “10:00 PM Flight” or “11:00 PM Flight”.

EVEN Example 3-3

EVEN Example 3-4

EVEN Function in VBA

In VBA, also we can use the EVEN function. The procedure to use this function is as below.

Sub EVEN_Function_Example
Dim Result as String
Result = Application.Worksheetfunction.Even(51.36)
Msgbox Result
End Sub

If you run the above code message box will show you the result as 52.

Things to Remember

  • It can be applied to a single cell, not a range of cells. If you use it for multiple cells, only the first cell will be its reference. Look at the example below; we have selected two numbers, but it shows the even number only for the number 75, and 76 is the nearest EVEN number.

EVEN Example 4-1

Result is :

EVEN Example 4-2

  • It can be applied only to a series of numbers. If applied to something other than numbers, it will throw the error as #VALUE!

EVEN Example 4-3

The result will be :

EVEN Example 4-4

  • If the number is exactly between the two EVEN numbers, a function always rounds up the number and shows the result. It will never round down the value. In the below example, the supplied number is 55.

EVEN Example 4-5

In this case, the result will be 56, not 54.

EVEN Example 4-6

  • We can directly enter the number for the parameter and need not specify the cell reference.
  • It always rounds up for positive numbers, but it will round down for negative numbers, but the more negative it will be

EVEN Example 4-7

Result is :

EVEN Example 4-8

Recommended Articles

This has been a guide to EVEN Function. Here we discuss the EVEN Formula and How to use the EVEN Function, along with an example and downloadable Excel template. You may also look at these useful functions in Excel –

  1. AND Function in Excel
  2. XIRR in Excel
  3. ODD Excel Function
  4. OR Formula in Excel
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download EVEN Excel Function Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download EVEN Excel Function Template

EDUCBA

डाउनलोड EVEN Excel Function Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more