TRUNC function
The TRUNC function is one of the math and trigonometry functions. It is used to return a number truncated to a specified number of digits.
Syntax
TRUNC(number, [num_digits])
The TRUNC function has the following arguments:
| Argument | Description |
|---|---|
| number | A number to truncate. |
| num_digits | A number of decimal places to display. It is an optional argument. If omitted, the function will assume it to be 0. |
Notes
How to apply the TRUNC function.
Examples
The figure below displays the result returned by the TRUNC function.
