ROUNDUP:
Rounds a number down, toward zero
The ROUNDUP function rounds a number down, toward zero.
ROUNDUP takes
1 required argument and
1 optional argument:
Syntax: ROUNDUP(number,
[num_digits])
Using the ROUNDUP function:
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. 
• 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. 
The ROUNDUP function rounds a number down, toward zero.