Skip to content
Google Sheets

INT function in Google Sheets

Rounds a number down to the nearest integer that is less than or equal to it.

=INT(value)

INT syntax and parameters

One argument, one required.

  • valuenumberRequired

    The value to round down to the nearest integer..

INT examples

Formulas you'll actually reuse.

  1. The whole part — rounds DOWN, so −2.5 becomes −3:

    =INT(B2)

    Result7

  2. Just the fraction — e.g. the time of day out of a date-time serial:

    =B2 - INT(B2)

    Result0.75

INT in Excel

Same name — your formula ports as-is.

Try INT in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.