TRUNC

Description Truncates the given number to an integer.

Syntax TRUNC ( number [, precision] )

Argument	Description
number	Any value.
[precision]	Optional. The number of decimal places allowed in the truncated number. If this argument is omitted, 0 is used.

Remarks TRUNC removes the fractional part of a number to the specified precision without rounding the number.

Examples This function returns 123.45:

TRUNC(123.456, 2)

This function returns 9800:

TRUNC(9899.435, -2)

See Also CEILING, FLOOR, INT, MOD, ROUND