Skip to content
Google Sheets

ROUND function in Google Sheets

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

=ROUND(value, [places])

ROUND syntax and parameters

Two arguments, one required.

  • valuenumberRequired

    The value to round to places number of places.

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

ROUND examples

Formulas you'll actually reuse.

  1. Gross price to the cent — no floating-point tails in totals:

    =ROUND(B2 * 1.19, 2)

    Result23.79

  2. To the nearest thousand — negative digits round left of the point:

    =ROUND(B2, -3)

    Result148000

ROUND in Excel

Same name — your formula ports as-is.

Try ROUND in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.