TRUNC
Calculates the value of the specified number with its fractional component removed. The TRUNC function does not perform any rounding.
Syntax
=TRUNC(value)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to truncate |
Examples
=TRUNC(3.1459)→3
Truncates the value 3.14159
=TRUNC(1.9)→1
Truncates the value 1.9
=TRUNC(-2.1)→-2
Truncates the value -2.1
=TRUNC(-2.9)→-2
Truncates the value -2.9
=TRUNC(2)→2
Truncates the value 2
=TRUNC(0)→0
Truncates the value 0
Updated 9 months ago