| Syntax |
| =TRUNC(number,[num_digits]) |
| Purpose / Description |
| Returns a value which has had its precision changed by truncating at a position to the left or right of the decimal place. Truncation does not involve rounding, the result is the remaining significant digits after the indicated digits are removed. |
| Arguments |
| Name |
Type |
Description |
| number |
number |
A reference or nested expression that returns a valid reference, a constant or a nested expression that returns a numeric value to be truncated. Normal coercion rules apply and where a non-numeric value can be coerced to a number it will be. |
| num_digits |
number |
An optional reference or nested expression that returns a valid reference, a constant or a nested expression that returns a numeric value that indicates the position of truncation. Positive values truncate the result that number of positions to the right of the decimal, negative values truncate that many positions to the left of the decimal, replacing truncated numbers with 0, and zero indicates truncation to whole number. Normal coercion rules apply and where a non-numeric value can be coerced to a number it will be. If omitted, the value 0 is used. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
|
Returns the truncated result, in which the precision of the value matches that given by the optional num_digits argument. |
| error |
#VALUE! |
If the value of either number or num_digits is not a number and is not capable of coercion to a number. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Comment: |
This function is a powerful solution to problems involving calculating offsets in arrays and tables. |
| Advice: |
We would strong recommend using this in preference to the INT function, as the INT function produces a lower value, which is further from zero when negative, whereas the TRUNC function produces the same absolute value either side of zero! |
| Examples: |
Open / download sample workbook: INT, TRUNC.xlsx |
| |