EVEN
Formulas / EVENRound numbers up to the next even integer.
==EVEN(number)
- number - the value to round
Examples
=EVEN(1.5)The function accepts a single number as its argument and will return the nearest even number to that number. For example, this formula will return 2 as the nearest even integer to 1.5.
=EVEN(-1)The function can also accept negative numbers as its argument and, will return -2 as the nearest even integer to -1.
=EVEN(2)The function will return the same even number if the argument is already an even number,and will return 2 as the nearest even integer to 2.
=EVEN(3)The function will round up to the next even number if the argument is an odd number, and will return 4 as the nearest even integer to 3.
Need help with Formulas?
Summary
The EVEN function is used for rounding numbers up to the next even integer. Negative numbers are rounded away from zero and even integers are the next even integer up from the original number and zero.
- The EVEN function takes one argument - the argument should be a numeric value.
- The EVEN function rounds numbers away from zero and up to the next integer.
- All numbers are evenly rounded up to the next integer number.
Frequently Asked Questions
What is the EVEN function?
What is the purpose of the EVEN function?
How do I use the EVEN function?
What are some examples of using the EVEN function?
- Rounding up 2.5 to the nearest even number: =EVEN (2.5) would return 4
- Rounding up 3.2 to the nearest even number: =EVEN (3.2) would return 4
- Rounding up 7.9 to the nearest even number: =EVEN (7.9) would return 8
What numbers can I use with the EVEN function?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.