Even() Function



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

OR Function