EVEN function

This topic describes the formula syntax and usage of the EVEN function in the Data Quality Execute Formula transform.

Description

Rounds a number up to the nearest even integer.

Syntax

EVEN(number)

The EVEN function syntax has the following argument:

  • number Required. The value to round.

Notes

  • If a number is nonnumeric, EVEN returns an error.
  • Number is rounded up from zero regardless of the sign of the number.

Example

Data Formula Description Result
3 Even([Data]) Rounds 3 up to nearest even integer 4
-3 Even([Data]) Rounds -3 up to nearest even integer -4
1.5 Even([Data]) Rounds 1.5 up to nearest even integer 2
2 Even([Data]) Rounds 2 up to nearest even integer 2
3.5 Even([Data]) Rounds 3.5 up to nearest even integer 4