Excel ROUNDUP function

Function              ROUNDUP

Description        Excel ROUNDUP function rounds up number to a given number of digit after or before decimal.

Syntax  ROUNDUP(number, num_digits)

number  The number to rounded up.

num_digits  The number of digits up to which rounding up number has to be rounded up.

Example:

=ROUNDUP(2.3456,2) = 2.35

=ROUNDUP(2.3126,2) = 2.32

=ROUNDUP(12.789,1) = 12.8

=ROUNDUP(12.789,-1) = 20

Usage Note:

  • When the num_digits is positive it rounds up right to the decimal point and when it is negative it rounds up left to the decimal point.
  • If the num_digits is 0 then rounds up to the nearest integer.