The Excel EVEN function
returns the next even integer after rounding a given number up. The EVEN
function always rounds numbers up (away from zero) so positive numbers
become larger and negative numbers become smaller (i.e. more negative).
Syntax
The syntax for the EVEN
function in Microsoft Excel is:
=EVEN( number )
Parameters or Arguments
number
A numeric value to round up to
the nearest even integer.
Even Function Examples
The following spreadsheet
shows several examples of the Excel Even function:
Formulas:
|
|
A
|
B
|
|
1
|
|
=EVEN(
23 )
|
|
2
|
2.22
|
=EVEN(
A2 )
|
|
3
|
|
=EVEN(
A2 + 4 )
|
|
4
|
0
|
=EVEN(
A4 )
|
|
5
|
-0.3
|
=EVEN(
A5 )
|
|
6
|
-11
|
=EVEN(
A6 )
|
|
7
|
-4
|
=EVEN(
A7 )
|
Results:
|
|
A
|
B
|
|
1
|
|
24
|
|
2
|
2.22
|
4
|
|
3
|
|
8
|
|
4
|
0
|
0
|
|
5
|
-0.3
|
-2
|
|
6
|
-11
|
-12
|
|
7
|
-4
|
-4
|
The above examples show how
the Even function always rounds away from zero. I.e. If the supplied number is
positive, it is rounded up (more positive), but if the supplied number is
negative, it is rounded down (more negative).
References
No comments:
Post a Comment