INT function

Rounds a number down to the nearest integer. Negative numbers round down to the integer less than the number.

Syntax

INT (number)

This function returns number rounded down to the nearest integer.

Example

=INT(5.7) returns 5.

=INT(-1.3) returns -2.