truncate PowerHome formula function
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
|
Return value
The data type 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.