The ROUNDUP function is to round a number down away from zero with the number of digits you defined.
Formula:
=ROUNDUP(number, num_digits)
Explanations:
– The number is required, which is the number to round.
– The num_digits is required, which is the number of digits you need to keep.
Cautions:
– When the num_digits is less than 0, the number is rounded to the left of the decimal point.
=ROUNDUP(2.56,0) The result returns 3.
=ROUNDUP(2.156,1)
The result returns 2.2.
=ROUNDUP(2.156,2)
The result returns 2.16.