The INT function

Rounds a number down to the nearest whole number. Negative numbers go further from zero: INT(-7.9) is -8.

Syntax

INT(number)
number
The number to round down.

Examples

B1=INT(7.9)
AB
17
B1=INT(-7.9)
AB
1-8

Related functions