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)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.