How to use EVEN function in Microsoft Excel

This article describes the formula syntax and usage of the EVEN function in Microsoft Excel.

Purpose

Rounds a number up to the nearest even integer.

Sample Usage

EVEN(3)

EVEN(-0.6)

EVEN(A2)

Syntax

EVEN(value)

  • value – The value to round to the next greatest even number.
    • If value is negative, it will be rounded down to the next negative even number with greater absolute value.

Example:

Result Formula
828 =EVEN(826.745)
-112 =EVEN(-110.2)
112 =EVEN(110.2)