Author: Oscar Cronquist Article last updated on March 13, 2019

The ROUNDUP function calculates a number rounded up based on the number of digits to which you want to round the number.

Formula in cell D3:


Excel Function Syntax

ROUNDUP(number, num_digits)


number Required. The value to round.
num_digits Required. A number representing the digit you want to round up to.


The ROUNDUP function rounds

  • up to the given decimal if num_digit is larger than 0 (zero).
  • up to the nearest integer if num_digit is 0 (zero).
  • up the number to the left of the decimal point if num_digit is less than 0 (zero).