[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
EVEN ( x )
Description: Computes x rounded to the nearest even integer, away from zero. Regardless of the sign of x, a value is rounded up when adjusted away from zero.
Arguments:
|
Name |
Type |
Description |
|
number |
The value to be rounded. |
Return Type and Value: number – The rounded value of x. If x is zero, the result is zero.
[Example:
EVEN(1.5) rounds 1.5 up to the nearest even integer; that is, to 2.
EVEN(3) rounds 3 up to the nearest even integer; that is, to 4.
EVEN(2) rounds 2 up to the nearest even integer; that is, to 2.
EVEN(-1) rounds -1 up to the nearest even integer; that is, to -2.
end example]