1. Home
  2. Functions
  3. Math
  4. EVEN

EVEN function

Rounds a number away from zero to the nearest even integer.

Syntax

=EVEN(number)

Arguments

ArgumentRequiredDescription
numberRequiredThe number

How to use EVEN

EVEN takes 1 required argument. Type =EVEN( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=EVEN(1.5)Result 2
=EVEN(3)Result 4
=EVEN(-1)Result -2

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.