EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel EVEN Excel Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

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, if we feed an even number, then it will not be changed, and it only considers numbers.

EVEN Formula in Excel:

Below is the EVEN Formula in Excel :

Start Your Free Excel Course

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

EVEN Formula in excel

EVEN Formula includes only one argument.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,452 ratings)
  • Number: It is the required parameter and 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 EVEN Function in excel by 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. This is because the nearest integer EVEN number is 4, not 2.
  • The fourth one is -0.39; here, 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 below list and count how many EVEN numbers are there in the list.

EVEN Example 2-1

We can find the total number of EVEN numbers in the by using EVEN formula and COUNTIF formula.

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

EVEN Function Example 2-2

Result is :

EVEN Function Example 2-2.1

If it is, EVEN number show as TRUE.

EVEN Function Example 2-3

If it is, the ODD number show as FALSE.

EVEN Function Example 2-4

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

EVEN Example 2-5

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

EVEN Example 2-6

Here COUNTIF formula counts all the TRUE values in the range B2: B18 and return the total count of all the TRUE values. The total number of TRUE values in the range 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, then schedule them at 10:00 PM flight. If the ticket number is an ODD number, then schedule them for the 11:00 PM flight.

EVEN Example 3-1

Now enter this data in excel and start following the below steps to allocate flight to either 10:00 PM or 11:00 PM.

Check if the ticket number is equal to the EVEN number show as “10:00 PM Flight” or else “11:00 PM Flight”.

EVEN Function Example 3-2

Firstly, we are checking whether the ticket number is equal to 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 else “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 for the range of cells. If you apply it for more than one cell, only the first cell will be its reference. Look at the below example; we have selected two numbers, but it is showing 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 it is 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 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
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
2 Shares
Share
Tweet
Share
Primary Sidebar
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

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

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

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

EDUCBA Login

Forgot Password?

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

EDUCBA
Free Excel Course

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

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

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

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

Let’s Get Started

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

EDUCBA

Download EVEN Excel Function Template

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