Documentation/Calc Functions/EVEN

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

EVEN

Category:

Mathematical

Summary:

Rounds a positive number up to the next even integer and a negative number down to the next even integer.

Syntax:

EVEN(Number)

Returns:

Returns Number rounded to the next even integer up, away from zero.

Arguments:

Number is a real number or a reference to the cell containing that number whose even rounded up/down value is to be calculated.

Additional details:

None

Examples:

Formula Description Returns
=EVEN(2.3) rounds up 2.3 to the nearest even integer 4
=EVEN(2) rounds up 2 to the nearest even integer 2
=EVEN(0) rounds up 0 to the nearest even integer 0
=EVEN(-0.5) rounds down -0.5 to the nearest even integer -2
=EVEN(-5) rounds down -5 to the nearest even integer -6

Related LibreOffice functions:

ODD

CEILING

ODF standard:

Section 6.16.30, part2

Equivalent Excel functions:

EVEN