ROUNDDOWN Function

Rounds a number down, towards zero.

Category

Math & Trig

Available in

All versions, Microsoft 365

Returns

A number

Taught hands-on in Level 4: Advanced Dynamic Arrays & Logic · Advanced Math & Text module

Overview

ROUNDDOWN always rounds towards zero, simply cutting off the extra digits: 2.99 becomes 2.

It's the right choice for “how many complete…”: full boxes you can fill, whole years of service, completed hours.

Syntax

=ROUNDDOWN(number, num_digits) Explain

Arguments

ArgumentRequired?What it does
numberYesThe number to round.
num_digitsYesDecimal places; 0 for whole numbers, negative for tens, hundreds…

Examples

Example 1 — Full boxes

How many full 12-unit boxes can we pack?

C2fx=ROUNDDOWN(B2/12, 0)
ABC
1BatchUnitsFull boxes
2A302
3B242
4C494
=ROUNDDOWN(B2/12, 0) Explain

Example 2 — Commission to the cent, never rounded up

Pay commission without ever rounding in the rep's favour.

=ROUNDDOWN(B2*3.5%, 2) Explain

Common mistakes

  • Same as TRUNC. ROUNDDOWN(x, 0) and TRUNC(x) give the same answer; INT differs for negative numbers.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.