ROUNDUP

ROUNDUP —

ROUNDUP(number[,digits])

ROUNDUP function rounds a given number away from 0.

number is the number you want rounded away from 0 and digits is the number of digits to which you want to round that number.

If digits is greater than zero, number is rounded away from 0 to the given number of digits.
If digits is zero or omitted, number is rounded away from 0 to the next integer.
If digits is less than zero, number is rounded away from 0 to the left of the decimal point.
This function is Excel compatible.

ROUNDUP(5.5) equals 6.

ROUNDUP(-3.3) equals -4.

ROUNDUP(1501.15,1) equals 1501.2.

ROUNDUP(1501.15,-2) equals 1600.0.

Synopsis