ROUNDUP Function

Rounds a number up, away from 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

ROUNDUP always rounds away from zero, whatever the next digit is: 2.01 becomes 3.

Use it whenever you can't have a part: boxes to ship, staff to roster, sheets of material to buy.

Syntax

=ROUNDUP(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 — Boxes needed

Each box holds 12 units. Any leftover needs another box.

C2fx=ROUNDUP(B2/12, 0)
ABC
1OrderUnitsBoxes
21001303
31002242
41003495
=ROUNDUP(B2/12, 0) Explain

Example 2 — Price to the next dollar

Round prices up to a whole dollar.

=ROUNDUP(B2, 0) Explain

Common mistakes

  • Negative numbers go further negative. ROUNDUP(−2.1, 0) is −3 (away from zero). Use CEILING.MATH if you want −2.

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.