MathLevel: BeginnerAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Related functions
ROUNDDOWN removes digits without rounding up — for example to calculate completed years or whole units.
Syntax
=ROUNDDOWN(number, num_digits)
| Argument |
What it means |
num_digits |
Digits to keep. |
Examples
Example 1
=ROUNDDOWN(B2/1000, 0)*1000
Round an amount down to the thousand.
Example 2
=ROUNDDOWN(YEARFRAC(A2, TODAY()), 0)
Completed years of service.
ROUNDUP · INT · TRUNC
📚 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