Skip to content
Google Sheets

ROUNDDOWN function in Google Sheets

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

=ROUNDDOWN(value, [places])

ROUNDDOWN syntax and parameters

Two arguments, one required.

  • valuenumberRequired

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

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

ROUNDDOWN examples

Formulas you'll actually reuse.

  1. Whole hours out of a minute count:

    =ROUNDDOWN(B2 / 60, 0)

    Result2

  2. Toward zero to the hundred below — a conservative estimate:

    =ROUNDDOWN(B2, -2)

    Result12400

ROUNDDOWN in Excel

Same name — your formula ports as-is.

Try ROUNDDOWN in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.