EVEN takes just one argument,number, which should be a numeric value.
With positive numbers, EVEN roundsnumberup to the next even integer.
With negative values, EVEN roundsnumberdown away from zero to the next negative integer.
With zero (0) and numbers that are already even integers,numberis unchanged.
EVEN Function
The Excel EVEN function rounds numbers up to the next even integer.
ROUND Function
The Excel ROUND function returns a number rounded to a given number of digits.
The ROUND function can round to the right or left of the decimal point.
ROUNDDOWN Function
The Excel ROUNDDOWN function returns a number rounded down to a given number of places.
MROUND will round a number up or down, depending on the nearest multiple.
FLOOR Function
The Excel FLOOR function rounds a given number down to the nearest specified multiple.
FLOOR works like the MROUND function, but FLOORalways rounds down.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3.
The TRUNC function does no rounding, it simply truncates as specified.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
