Truncation Functions

CEIL

returns the smallest integer the argument

CEILZ

returns the smallest integer that is greater than or equal to the argument, using zero fuzzing

FLOOR

returns the largest integer the argument

FLOORZ

returns the largest integer that is less than or equal to the argument, using zero fuzzing

FUZZ

returns the nearest integer if the argument is within 1E-12

INT

returns the integer portion of a value

INTZ

returns the integer portion of the argument, using zero fuzzing

MODZ

returns the remainder from the division of the first argument by the second argument, using zero fuzzing

ROUND

rounds a value to the nearest round-off unit

ROUNDE

rounds the first argument to the nearest multiple of the second argument, and returns an even multiple when the first argument is halfway between the two nearest multiples

ROUNDZ

rounds the first argument to the nearest multiple of the second argument, with zero fuzzing

TRUNC

returns a truncated numeric value of a specified length