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) |