TRUNC
Truncates a number to an integer by removing the fractional part of the number
Syntax
TRUNC(number, [num_digits])
Parameters
- number: Required. The number you want to truncate
- num_digits: Optional. A number specifying the precision of the truncation (default 0)
Example
=TRUNC(8.9)