Function reference 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. |
Data type: Number 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.
Example 1
Section titled “Example 1”Truncate(9.22, 1)
This expression returns 9.2
Example 2
Section titled “Example 2”Truncate(9.28, 1)
This expression returns 9.2
Example 3
Section titled “Example 3”Truncate(9.9, 0)
This expression returns 9
Example 4
Section titled “Example 4”Truncate(–9.29, 1)
This expression returns -9.2
Example 5
Section titled “Example 5”Truncate(9.2, –1)
This expression returns 0
Example 6
Section titled “Example 6”Truncate(54, –1)
This expression returns 50