EVEN

See also A-Z Spreadsheet Function List

Description Rounds the specified number up to the nearest even integer.

Syntax EVEN(number)

number is any number, a formula that evaluates to a number, or a reference to a cell that contains a number.

See Also CEILING , FLOOR , INT , ODD , ROUND , and TRUNC functions

Examples EVEN(2.5) returns 4

         EVEN(2030.45) returns 2032