INT

Try it

When to use it

When should I use INT instead of ROUNDDOWN or TRUNC?

INT rounds down to the nearest whole number, so for negatives it moves away from zero (INT(-2.5) is -3). TRUNC and ROUNDDOWN simply drop the decimals toward zero (-2). Pick INT when you want a true mathematical floor.

Can I use INT to extract the whole-dollar part of an amount?

Yes. INT(amount) gives the whole units, and amount minus INT(amount) gives the fractional remainder, which is handy for splitting currency into dollars and cents.

Use cases

Floor a negative value away from zero

Whole-dollar portion of a price

Used in

operations

Syntax

INT(number)

Examples

=INT(99.44) // => 99
=INT(-8.9) // => -9
=INT(7) // => 7