MathLevel: BeginnerAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Example 3
- Related functions
INT rounds a number down to the nearest integer. On dates with times, it strips the time.
Syntax
=INT(number)
| Argument |
What it means |
number |
Any number. |
Examples
Example 1
=INT(8.9)
8.
Example 2
=INT(-8.9)
−9 (down, not towards zero — use TRUNC for −8).
Example 3
=INT(A2)
Date only from a date-time stamp.
TRUNC · ROUNDDOWN · MOD
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong