ROUNDUP

ROUNDUP

Rounds a number up, away from 0 (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 number.

Remarks

  • 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 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.92654, -2) equals 31,500