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.