Syntax
Int(Number)Examples
=Int(-3.7)-4 (always rounds down)
Maker notes
- For negative numbers, Int and Trunc differ: Trunc(-3.7) is -3.
Int
Rounds a number down to the nearest whole number.
Rounds a number down to the nearest whole number.
Int(Number)=Int(-3.7)-4 (always rounds down)