Syntax
=INT(value)
value- The number to round down.
INT function in Google Sheets
INT rounds a number down to the nearest whole number. For positive values it just drops the decimals. For negative values it moves further from zero.
Practice INT
Task 1 of 1
Convert the call length in minutes (A2) to whole hours, dropping any remainder. Answer in B2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
INT examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | |
|---|---|---|
| 1 | Value | Other |
| 2 | -7.45 | 3 |
| 3 | 12.5 | 4 |
| 4 | 81 | 2 |
| 5 | 2.5 | 0 |
| 6 | 1234.567 | 5 |
| Formula | Result | What it shows |
|---|---|---|
=INT(A6) | 1234 | Drops the decimals. |
=INT(A2) | -8 | Rounds down, so a negative goes to -8, not -7. |
=INT(A3 / B3) | 3 | Whole number of times one value fits into another. |
Tips and common mistakes
- Pair INT with MOD to split a quantity into whole units and leftovers, e.g. hours and minutes.
- Use ROUNDDOWN if you want negative numbers to round toward zero instead.
Related functions
Learning step by step? INT is covered in Lesson 32: MEDIAN, MOD, ABS & More Math of the free course.