ROUNDUP

Description

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

Syntax

ROUNDUP ( number, numberOfDigits )

Parameter Description
number Any real number you want to round.
precision The number of decimal places to which number is rounded.

If precision is negative, 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 to the nearest integer.

Examples

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