In the process, the function will increase the value of the rounding digit by one.

(In this case betweenA2and2.)

Select cellsee the function= ROUNDUP(A2, 2 )in theformula barabove theworksheet.

Excel’s ROUNDUP function in action.

Number(required) is the value you want to round up.

Num_digits(required) is the number of digits that you want to round theNumberargument to.

The results, shown in column B, depends on the value of the Num_digits argument.

Rounding numbers in Excel

This function will always round upward, such as 4.649 to 4.65.

When you use the ROUNDUP function on negative numbers, they decrease in value (away from zero).