ReferenceFunctionsMath Functions

EVEN

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

Summary

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

Remarks

Values already equal to an even integer stay unchanged.
Positive and negative values both move away from zero.
0 returns 0.

Examples

Round a positive number to even

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

4

Round a negative number away from zero

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-2

FAQ

Does EVEN ever round toward zero?

No. It always rounds away from zero to the nearest even integer.

Runtime metadata

Category

Math

Signature

EVEN(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

DEGREES

Converts an angle from radians to degrees.

EXP

EXP: Returns Euler's number `e` raised to the given power.

On this page

Summary Remarks Examples Related functions FAQ Does EVEN ever round toward zero?Runtime metadata