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 8 months ago