Description
The Excel EVEN function rounds up any referred number to the nearest EVEN number.
(In the example given in the image above, 30.05 is rounded up to 32).
Excel EVEN function belongs to the rounding functions, which rounds the fractional numbers to the nearest integers.
However, unlike the INT function (in which fractional numbers are rounded down to the nearest Integer), this function rounds up the EVEN numbers.
NOTE:
Remember that the Excel ODD function is different from the ISEVEN function, which is a conditional function and returns the logical values (TRUE/ FALSE) if the given criteria are met.
=ODD(number)
Excel even function syntax
The EVEN function’s syntax has the following argument:
- number Required
This argument shall be the number (even stored as text) or reference to the number you want to round. In the example given in the image above the number “29.55” and the cell B3 (i.e. reference to the number) is our required argument.
