Search
Clear search
Close search
Google apps
Main menu

ROUNDUP

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

Sample Usage

ROUNDUP(99.44,1)

ROUNDUP(A2)

Syntax

ROUNDUP(value,places)

  • value - The value to round to places number of places, always rounding up.

  • places - [ OPTIONAL - 0 by default ] - The number of decimal places to which to round.

    • places may be negative, in which case value is rounded at the specified number of digits to the left of the decimal point.

Notes

  • ROUNDUP operates like ROUND except that it always rounds up.

See Also

TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits.

ROUNDDOWN: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

ROUND: Rounds a number to a certain number of decimal places according to standard rules.

MROUND: Rounds one number to the nearest integer multiple of another.

INT: Rounds a number down to the nearest integer that is less than or equal to it.

FLOOR: Rounds a number down to the nearest integer multiple of specified significance.

CEILING: Rounds a number up to the nearest integer multiple of specified significance.

Examples

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?