ROUNDUP pitfall 1: Always rounds AWAY from zero: ROUNDUP(-3.1, 0) returns -4, not -3?

Always rounds AWAY from zero: `ROUNDUP(-3.1, 0)` returns `-4`, not `-3`. Use `CEILING` if you want round-toward-positive-infinity semantics.

ROUNDUP pitfall 2: Don't use to fix floating-point display drift; use cell formatting instead?

Don't use to fix floating-point display drift; use cell formatting instead. ROUNDUP changes the underlying value.

Matheasy

Rounds a number up to the next integer or decimal place, away from zero.

Syntax

=ROUNDUP(value, [places])

Arguments

Argument	Description
value	The value to round up.
[places]	The number of decimal places to round to. Negative values round to the left of the decimal.

Example

=ROUNDUP(3.14, 1)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and ROUNDUP isn't one of them yet.

Always rounds AWAY from zero: ROUNDUP(-3.1, 0) returns -4, not -3. Use CEILING if you want round-toward-positive-infinity semantics.
Don't use to fix floating-point display drift; use cell formatting instead. ROUNDUP changes the underlying value.

Related formulas

Used by