Skip to content
Google Sheets

ROUNDUP function in Google Sheets

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

=ROUNDUP(value, [places])

ROUNDUP syntax and parameters

Two arguments, one required.

  • valuenumberRequired

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

  • placesnumberOptional

    [ 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.

ROUNDUP examples

Formulas you'll actually reuse.

  1. Boxes needed for B2 items at 12 per box — always round up:

    =ROUNDUP(B2 / 12, 0)

    Result9

  2. A price rounded up to the next 10 cents:

    =ROUNDUP(B2, 1)

    Result23.8

ROUNDUP in Excel

Same name — your formula ports as-is.

Try ROUNDUP in the playground

Edit the example — nothing to install.

Preloaded with the ROUNDUP formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.