Formulas and Functions

Chapter 8 Numeric Functions 173
EVEN
The EVEN function rounds a number away from zero to the next even number.
EVEN(num-to-round)
 num-to-round: The number to be rounded. num-to-round is a number value.
Usage Notes
To round to an odd number, use the ODD function. Â
Examples
=EVEN(1) returns 2.
=EVEN(2) returns 2.
=EVEN(2.5) returns 4.
=EVEN(-2.5) returns -4.
=EVEN(0) returns 0.
Related Topics
For related functions and additional information, see:
“CEILING” on page 170
“FLOOR” on page 176
“INT” on page 17 8
“MROUND” on page 183
“ODD” on page 185
“ROUND” on page 191
“ROUNDDOWN” on page 192
“ROUNDUP” on page 193
“TRUNC” on page 204
“More on Rounding” on page 355
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41