Functions
TRUNC
Truncate to integer or decimal places
Try it
When to use it
When should I use TRUNC instead of INT or FLOOR?
Use TRUNC when you want to drop decimal places without rounding, especially for negative numbers — unlike INT, TRUNC always truncates toward zero.
Use cases
Drop fractional part of a positive number
Used in
operations · science · engineering
Syntax
TRUNC(number, digits)Examples
=TRUNC(3.141592654,2) // => 3.14
=TRUNC(1.9,0) // => 1
=TRUNC(1.23) // => 1