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