This function returns an even integer after rounding a value up to the nearest even integer.
Syntax:
=EVEN (number)
Parameter list:
number – the number that will be rounded up to the nearest even integer.
For Example :
=EVEN(12.3) , returns nearest round up even number 14.
=EVEN(21.2), returns nearest round up even number 22 and so on.
EVEN returns the #VALUE! error value if number is nonnumeric.
Negative numbers are rounded “up” away from zero, making them even more negative.
Ask Your Query