Even

Syntax

Even(Value)

Parameters

Value. Rounded value.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

Description

It returns the result of rounding the value to the nearest even integer.

Example

Formula Result Description
=Even(2.6) 4 It rounds the 2.6 number to the nearest even integer.
=Even(B6) -6 Rounds the number from the B6 cell to the nearest even integer. The B6 cell contains the -5 number.

See also:

Function Wizard │ Mathematical Functions │ Ceiling │ Floor │ Int │ MRound │ Odd │ Round │ RoundDown │ RoundUp │ Trunc