Undocumented ROUNDUP() and ROUNDDOWN() Functions

MORE INFORMATION

ROUNDUP()

The Roundup function rounds a number up, away from zero.

Syntax:

   ROUNDUP(number, num_digits)
				

Number is any real number that you want rounded up. Num_digits is the number of digits to which you want to round the number.

ROUNDUP() behaves similarly to the ROUND() function, except that it always rounds a number up based on the following rules:

• If num_digits is greater than 0, then number is rounded up to the specified number of decimal places.
• If num_digits is 0 or omitted, 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.

Examples:

   ROUNDUP(3.2,0) equals 4
   ROUNDUP(76.9,0) equals 77
   ROUNDUP(3.14159, 3) equals 3.142
   ROUNDUP(-3.14159, 1) equals -3.2
   ROUNDUP(31415.926, -2) equals 31500
				

ROUNDDOWN()

Rounds a number down, toward zero.

Syntax:

   ROUNDDOWN(number, num_digits)
				

Number: any real number that you want rounded down. Num_digits: the number of digits to which you want to round number.

ROUNDDOWN() behaves similarly to the ROUND() function, except that it always rounds a number down based on the following rules:

• If num_digits is greater than 0, then number is rounded down to the specified number of decimal places.
• If num_digits is 0 or omitted, then number is rounded down to the nearest integer.
• If num_digits is less than 0, then number is rounded down to the left of the decimal point.

Examples:

   ROUNDDOWN(3.2, 0) equals 3
   ROUNDDOWN(76.9,0) equals 76
   ROUNDDOWN(3.14159, 3) equals 3.141
   ROUNDDOWN(-3.14159, 1) equals -3.1
   ROUNDDOWN(31415.92654, -2) equals 31400