TRUNC function
TRUNC truncates a number by removing decimal places.
Syntax
TRUNC(number, count)
Returns number with at most count decimal places. Excess decimal places are removed, irrespective of sign.
TRUNC(Number; 0) returns the same results as INT(Number) for positive numbers, but effectively rounds towards zero for negative numbers.
Example
=TRUNC(1.239,2) returns 1.23. The 9 is lost.
=TRUNC(-1.234999,3) returns -1.234. All the 9s are lost.