The ROUNDUP function rounds a number down, toward zero.

ROUNDUP takes 1 required argument and 1 optional argument:

Syntax: ROUNDUP(number, [num_digits])

#1)
Using the ROUNDUP function:
#2)
The arguments for the ROUNDUP function are:
Argument Required? Description
number Required Any real number that you want rounded down.
num_digits Optional The number of digits to which you want to round the number argument.
#3)
A few more things:
ROUNDUP behaves like ROUND, except that it always rounds a number up.
If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
If num_digits is 0, then number is rounded up to the nearest integer.
If num_digits is less than 0, then number is rounded up to the left of the decimal point.

Summary

The ROUNDUP function rounds a number down, toward zero.
comments powered by Disqus