Skip to content
Google Sheets

FLOOR function in Google Sheets

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

=FLOOR(value, [factor])

FLOOR syntax and parameters

Two arguments, one required.

  • valuenumberRequired

    The value to round down to the nearest integer multiple of factor.

  • factornumberOptional

    [OPTIONAL - 1 by default] - The number to whose multiples value will be rounded. factor may not be equal to 0.

FLOOR examples

Formulas you'll actually reuse.

  1. Round a 7.8h timesheet entry down to the billing half-hour:

    =FLOOR(B2, 0.5)

    Result7.5

  2. Gross price rounded down to the nearest 5 cents:

    =FLOOR(B2 * 1.19, 0.05)

    Result23.75

FLOOR in Excel

Same name — your formula ports as-is.

Try FLOOR in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.