Excel EVEN Function

Excel EVEN Function

Summary

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).

Purpose

Round a number up to the next even integer

Return value

An even integer.

Syntax

=EVEN (number)

Arguments

Usage notes

The EVEN function always rounds up to the next even integer, skipping odd integers along the way. Note that negative numbers are rounded "up" away from zero, so they actually become more negative.

 

Excel EVEN Function

Summary

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).

Purpose

Round a number up to the next even integer

Return value

An even integer.

Syntax

=EVEN (number)

Arguments

Usage notes

The EVEN function always rounds up to the next even integer, skipping odd integers along the way. Note that negative numbers are rounded "up" away from zero, so they actually become more negative.