<< Click to Display Table of Contents >> TRUNC (truncate a number) |
Syntax:
TRUNC(Number [, n])
Description:
Returns the given number truncated to n digits after the decimal point.
n is the number of decimal places.
If n is omitted, Number is truncated to an integer.
If n is a negative value, Number is truncated to the left of the decimal point (see last example).
Example:
TRUNC(5.779) returns 5
TRUNC(5.779, 2) returns 5.77
TRUNC(1234, -2) returns 1200
Annotation:
To obtain the decimal places use the DECIMALS function.
See also: