Excel function ROUNDUP

The ROUNDUP function makes it possible to round a number up to a specified number of decimal places.

Select the ROUNDUP function.

  • In the "Number" field, enter the name of the cell to round up.
  • In the "Num_digits" field, enter the number of decimal points you would like to round up to.

Click OK.

roundup function - roundup

The number has been rounded up.

roundup - roundup

To round all the numbers up, you can simply do an AutoFill series.

roundup autofill - roundup