How to Use ROUNDUP Function

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.

ROUNDUP Function

Leave a Reply