ROUNDUP

  • Updated

Rounds up a given number to a specified number of digits.

Sample Usage

ROUNDUP(15.55,0)
ROUNDUP(15.55, 1)
ROUNDUP(C5)

Syntax

ROUNDUP(number, [count])

  • number - The number to be rounded.
  • count - [OPTIONAL] The number of places to which the number is to be rounded.

Examples

ROUNDUP(15.55,0) returns the number 16.
ROUNDUP(15.55, 1) returns the number 15.6.

Notes

  • ROUNDUP behaves like ROUND, except that it always rounds a number up.
  • If count is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
  • If count is 0, the number is rounded to the nearest integer.
  • If count is less than 0, the number is rounded to the left of the decimal point.