Part 1: Introduce
Definition:
The EVEN function in Microsoft Excel is designed to round a given number up to the nearest even integer.
Purpose:
This function is handy for scenarios involving items in pairs or twos. For instance, if you have a packing crate that can accommodate rows of one or two things, the box is considered complete when the number of items, rounded up to the nearest two, matches the crate’s capacity.
Syntax & Arguments:
syntax
EVEN(number) Explain the Arguments in the function:
- Number: This is the only argument required for the EVEN function. It represents the value that you wish to round up.
Return value:
The EVEN function will return a number rounded to its nearest even integer.
Remarks:
- If the provided number is nonnumeric, the EVEN function will return the #VALUE! Error.
- Regardless of the sign of the number, the value will be rounded up when adjusted away from zero. If the number is already an even integer, no rounding will occur.
Part 2: Examples
Example 1:
- Purpose of illustration: To round the number 1.5 to its nearest even integer.
- Data sheet and formulas:
| A | B | C | |
|---|---|---|---|
| 1 | Number | Formula | Result |
| 2 | 1.5 | =EVEN(A2) | 2 |
- Explanation: The number 1.5, when rounded up to the nearest even integer, gives 2.
Example 2:
- Purpose of illustration: To round the number 3 to its nearest even integer.
- Data sheet and formulas:
| A | B | C | |
|---|---|---|---|
| 1 | Number | Formula | Result |
| 2 | 3 | =EVEN(A2) | 4 |
- Explanation: The number 3, when rounded up to the nearest even integer, gives 4.
Example 3:
- Purpose of illustration: To check the rounding of an already even number, 2.
- Data sheet and formulas:
| A | B | C | |
|---|---|---|---|
| 1 | Number | Formula | Result |
| 2 | 2 | =EVEN(A2) | 2 |
- Explanation: Since 2 is already an even number, the result remains 2.
Example 4:
- Purpose of example: To round a negative number, -1, to its nearest even integer.
- Data sheet and formulas:
| A | B | C | |
|---|---|---|---|
| 1 | Number | Formula | Result |
| 2 | -1 | =EVEN(A2) | -2 |
- Explanation: The number -1, when rounded up to the nearest even integer, gives -2.
Example 5:
- Purpose of illustration: To round the number 4.5 to its nearest even integer.
- Data sheet and formulas:
| A | B | C | |
|---|---|---|---|
| 1 | Number | Formula | Result |
| 2 | 4.5 | =EVEN(A2) | 6 |
- Explanation: The number 4.5, when rounded up to the nearest even integer, gives 6.
Example 6: EVEN with IF
- Purpose of example: To determine if a number is odd and then round it up to the nearest even number.
- Data sheet and formulas:
| A | B | C | |
|---|---|---|---|
| 1 | Number | Formula | Result |
| 2 | 5 | =IF(MOD(A2,2)<>0, EVEN(A2), A2) | 6 |
- Explanation: The formula checks if the number in cell A2 is odd using the MOD function. It rounds if strange t up to the nearest even number using the EVEN function. In this case, 5 is weird, so it’s rounded to 6.
Example 7: EVEN with SUM
- Purpose of example: To sum a range of numbers and then round the result to the nearest even number.
- Data sheet and formulas:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Numbers | Formula | Result | |
| 2 | 3 | 4 | =EVEN(SUM(A2:B2)) | 8 |
| 3 | 5 | 6 |
- Explanation: The formula sums the numbers in cells A2 and B2, then rounds the result to the nearest even number. The sum of 3 and 4 is 7, rounded to 8.
Example 8: EVEN with VLOOKUP
- Purpose of example: To look up a value in a table and then round it to the nearest even number.
- Data sheet and formulas:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Lookup | Value | Formula | Result |
| 2 | Apple | 7 | =EVEN(VLOOKUP("Apple",A2:B3,2,FALSE)) | 8 |
| 3 | Banana | 5 |
- Explanation: The formula looks up the value associated with “Apple” in the table and then rounds it to the nearest even number. The value for “Apple” is 7, rounded to 8.
Example 9: EVEN with AVERAGE
- Purpose of example: To calculate the average of a range of numbers and then round the result to the nearest even number.
- Data sheet and formulas:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Numbers | Formula | Result | |
| 2 | 4 | 6 | =EVEN(AVERAGE(A2:B2)) | 6 |
| 3 | 8 | 10 |
- Explanation: The formula calculates the average numbers in cells A2 and B2, then rounds the result to the nearest even number. The average of 4 and 6 is 5, rounded to 6.
Example 10: EVEN with MAX
- Purpose of example: To find the maximum value in a range and round it to the nearest even number.
- Data sheet and formulas:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Numbers | Formula | Result | |
| 2 | 3 | 5 | =EVEN(MAX(A2:B2)) | 6 |
| 3 | 7 | 9 |
- Explanation: The formula finds the maximum value between cells A2 and B2, then rounds it to the nearest even number. The maximum value between 3 and 5 is 5, rounded to 6.
Example 11: EVEN with MIN
- Purpose of example: To find the minimum value in a range and round it to the nearest even number.
- Data sheet and formulas:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Numbers | Formula | Result | |
| 2 | 4 | 6 | =EVEN(MIN(A2:B2)) | 4 |
| 3 | 8 | 10 |
- Explanation: The formula finds the minimum value between cells A2 and B2, then rounds it to the nearest even number. The minimum value between 4 and 6 is 4, which remains 4 as it’s already even.
Example 12: EVEN with ROUNDUP
- Purpose of example: To round up a number to a specified number of digits and then round the result to the nearest even number.
- Data sheet and formulas:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Number | Digits | Formula | Result |
| 2 | 4.23 | 1 | =EVEN(ROUNDUP(A2,B2)) | 6 |
- Explanation: The formula rounds up the number in cell A2 to the number of digits specified in cell B2, then rounds the result to the nearest even number. The number 4.23 rounded up to 1 integer is 4.3, then rounded up to 6 using the EVEN function.
Part 3: Tips and tricks
- 🌟 Always ensure that the number you input into the EVEN function is numeric to avoid the #VALUE! Error.
- 🌟 Remember that the EVEN function will always round away from zero, regardless of the sign of the number.
- 🌟 The EVEN function can be handy when dealing with items that come in pairs or sets of two.