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:

=ROUNDUP(B3, C3)

Excel Function Syntax

ROUNDUP(number, num_digits)

Arguments

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

Comments

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).