WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel EVEN Function

Excel EVEN Function

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Even Function in Excel

EVEN is an inbuilt excel function, as the name suggests it rounds any given number to its even value, the number can be both negative or positive, so for example if the given input is =EVEN(-1.5) the rounded result will be -2, and if the given input is =EVEN(1.5) then the result is 2 and the keyword to use this function is =EVEN( with a number provided as an argument).

Syntax

EVEN Formula

  • number: A numeric value to round up to an even integer.

The number can be a numeric value or a cell reference containing a numeric value.

How to Use EVEN Function in Excel? (Examples)

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

Example #1

Suppose you have a list of numbers given in B3:B9.

EVEN Function Example 1

Now you want to convert these numbers to even numbers.

The syntax for the first number will be given as:

=EVEN(B3)

EVEN Function Example 1-1

Similarly, you can drag it for the rest of the cells-C4:C9 to get the output for the remaining ones.

EVEN Function Example 1-2

In the above example, you learned how to find an even number closest to the given number, away from zero. For example, a number 4.1 is closest to the even number 4; however, it will return 6. Sometimes, you may want to find the closest even number to a given number, be it higher or lower.

Example #2

In this example, suppose you have a list of numbers in B3:B6 for which you want to find the closest even number.

EVEN Function Example 2

You may use the following EVEN Formula for the first number 2.2 given in B3.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

=IF(EVEN(B3) –B3 > 1, EVEN(B3) -2, EVEN(B3))

EVEN Function Example 2-1

Here B3 = 2.2, and its nearest even number is 2. EVEN(B3) will return 4, which is 2 greater than its actual nearest even number.

Let us see the function in detail:

=IF(EVEN(B3) –B3 > 1, EVEN(B3) -2, EVEN(B3))

IF(EVEN(B3) –B3 > 1, if_true, if_false)

If EVEN(B3) is not the nearest even number of B3, then EVEN(B3) –B3 will be greater than 1.

if_true : EVEN(B3) -2

if_false: EVEN(B3)

If EVEN(B3) –B3 is greater than 1, it will subtract 2 to give the nearest even value, else return EVEN(B3).

EVEN Function Example 2-2

However, this EVEN Formula will not work with negative numbers. Suppose you have some negative numbers in cells B8:B10.

EVEN Function Example 2-3

For negative number (in B8), the following EVEN Formula may be used:

=IF(ABS(EVEN(B8) – B8) > 1, IF(B8<0, EVEN(B8) +2, EVEN(B8) -2), EVEN(B8))

EVEN Function Example 2-4

This will work for both negative and positive numbers. The main logic behind the EVEN Formula is:

If EVEN(B8) is not the nearest even number of B8, then EVEN(B8) ± 2 will be the nearest even number.

In this EVEN Formula,

ABS(EVEN(B8) – B8)

will return a positive value even if the difference is negative.

IF(ABS(EVEN(B8) – B8) > 1, if_true, if_false)

If |EVEN(B8) – B8| > 1, it means that EVEN(B8) is not the nearest even number.

if_true: IF(B8<0, EVEN(B8) +2, EVEN(B8) -2)

if_false: EVEN(B8)

means,

If |EVEN(B8) – B8| > 1, then

  • if the number in B8 is positive, it should subtract 2 from EVEN(B8), which will return the nearest even value.
  • if the number in B8 is negative, it should add 2 to EVEN(B8) which will return the nearest even value.

Else, EVEN(B8) is the nearest even value and should return as it is.

EVEN Function Example 2-5

Example #3

In this example, suppose you have a list of numbers, and you want to find out which numbers are even and which are odd.

EVEN Function Example 3

You may use the following EVEN Formula:

=IF(EVEN(B3) = B3, “Even”, “Odd”)

EVEN Function Example 3-1

It will return, “Odd.” Similarly, you can drag it to the rest of the cells.

EVEN formula Example 3-2

This can be alternatively done by using the ISEVEN in excel. It returns TRUE and FALSE statements.

Example #4

In this example, suppose you have a list of items needed to be packed. Similar items will be packed together. The items can be packed in a pair. You need to order the number of packing materials required for each item. As a precaution, you decide to order an extra packing material for each item.

EVEN formula Example 4

The syntax for an item C4 and its quantity in D4, the syntax is given as:

=(EVEN(D4))/2 + 1

EVEN formula Example 4-1

EVEN(D4)/2 will give the number of packing material required for packing 6 Vase, and it will return 3. Since we require one extra packing material, one is added to 3. It is to be noted here that the syntax is not given as =EVEN(D4/2).

Example 4-2

Things to Remember

  • It returns the nearest even value of number after rounding up and is adjusted away from zero.
  • It returns equal or a higher value when given a positive number.
  • It returns an equal or lower value when given a negative number.
  • If the number is a non-numeric value, EVEN returns the #VALUE! Error value.

Recommended Articles

This has been a guide to EVEN Function in Excel. Here we discuss the EVEN function and how to use it in excel along with examples and a downloadable template. You may also look at these useful post of excel –

  • RIGHT Function in Excel
  • ODD Function Excel
  • AGGREGATE Function
  • LOG Excel Function | Examples
  • Formatting Time in Excel
4 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download EVEN Function Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More