TRUNC function
Summary
Truncates a number to an integer
Syntax
TRUNC(number, [num_digits])
The TRUNC function syntax has the following arguments:
• Number Required. The number you want to truncate.
• Num_digits Optional. A number specifying the precision of the truncation. The default value for num_digits is 0 (zero).
• Number Required. The number you want to truncate.
• Num_digits Optional. A number specifying the precision of the truncation. The default value for num_digits is 0 (zero).
Example
=TRUNC(8.9)
=TRUNC(-8.9)
=TRUNC(0.45)
=TRUNC(-8.9)
=TRUNC(0.45)