Description
Truncates a number to the specified number of decimal places.
Syntax
Truncate ( x, n )
|
Argument |
Description |
|---|---|
|
x |
The number you want to truncate. |
|
n |
The number of decimal places to which you want to truncate x. Valid values are 0 through 28. |
Return value
The datatype of x. If n is positive, returns x truncated to the specified number of decimal places. If n is negative, returns x truncated to (- n +1) places before the decimal point. Returns -1 if it fails.
Examples
This expression returns 9.2:
Truncate(9.22, 1)
This expression returns 9.2:
Truncate(9.28, 1)
This expression returns 9:
Truncate(9.9, 0)
This expression returns -9.2:
Truncate(-9.29, 1)
This expression returns 0:
Truncate(9.2, -1)
This expression returns 50:
Truncate(54, -1)
See also
