ROUNDUP

Description Rounds the given number up to the supplied number of decimal places.

Syntax ROUNDUP ( number, number_of_digits)

Argument Description

number Any value you want to round up.

number_of_digits The number of decimal places to which number is rounded. When a negative precision is used, the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced with zeros. If precision is 0, number is rounded up to the nearest integer.

Argument	Description
number	Any value you want to round up.
number_of_digits	The number of decimal places to which number is rounded. When a negative precision is used, the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced with zeros. If precision is 0, number is rounded up to the nearest integer.

Example This function returns 77:

ROUNDUP(76.9,0)

This function returns 31500:

ROUNDUP(31415.92654, -2)

See Also CEILING, FLOOR, INT, MOD, ROUND, ROUNDDOWN, TRUNC