ROUNDUP

Description

ROUNDUP rounds the given number up to the supplied number of decimal places.

Syntax

ROUNDUP ( number, precision )

Parameter

Description

number

Any value you want to round up.

precision

Indicates the number of decimals to round to.

If a negative precision is used, the digits to the right of the decimal point are dropped and zeros replace the absolute number of significant digits specified by precision.

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)

Note:

If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.

Also, see