INT

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Rounds a number down to the nearest integer.

Syntax

INT ( number )

Number is the real number you want to round down to an integer.

Example 1

Formula

Description (Result)

=INT(8.9)

Rounds 8.9 down (8)

=INT(-8.9)

Rounds -8.9 down (-9)

Example 2

Col1

Formula

Description (Result)

19.5

=[Col1]-INT([Col1])

Returns the decimal part of a positive real number in Col1 (0.5)

Show: