Navigation:  Formula Reference > Spreadsheet Formula Functions >

EVEN

Previous pageReturn to chapter overviewNext page

 

This function rounds the specified value up to the nearest even integer.

Syntax

EVEN(value)

Arguments

The argument can be any numeric value.

Remarks

Regardless of the sign of the number specified by the argument, the number is rounded away from zero.

Data Types

Accepts numeric data. Returns numeric data.

Examples

EVEN(A3)

EVEN(R1C2)

EVEN(5) gives the result 6

EVEN(-2.5) gives the result -4

 

See Also

CEILING

FLOOR

ISEVEN

ODD