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