Skip to content
Klargrid

The ROUNDUP function

Always rounding up: a number of boxes, pages, started days. 2.1 becomes 3.

Syntax

=ROUNDUP(number, num_digits)

In a French Excel: =ARRONDI.SUP(nombre; no_chiffres).

Arguments

  • number: the value.
  • num_digits: 0 for whole numbers, 2 for cents, -1 for tens.

An example

=ROUNDUP(A2/12,0)

The number of boxes of 12 for A2 items: a started box counts.

Pitfalls

  • Negative numbers round away from zero: -2.1 becomes -3.
  • ROUNDDOWN does the opposite: it truncates towards zero.

Going further

  • ROUND.
  • INT, which rounds down even negatives.

Frequently asked questions

What is the difference with CEILING?
CEILING rounds up to the next multiple of a given step (5, 0.25); ROUNDUP to a number of decimals.