BeginnerTotals and maths
Syntax
=INT(number)| Argument | What it means |
|---|---|
number | The number to round down. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Examples that need no data
=INT(8.9)Drops the decimals
=INT(-1.5)Rounds down, so negative numbers go further from zero
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use INT at work
- Operations
How many full boxes of 12 can you make from the stock?
Data: Stock levels (fictional)=INT(C2/12) - Administration
Whole weeks in a number of days.
=INT(30/7)
Common mistakes and tips
- INT rounds down, not towards zero. For negative numbers use ROUNDDOWN or TRUNC if you want to just cut the decimals.
Works in
All versions of Excel, and Google Sheets.
Related formulas
Lessons that use it
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.