INT

Formulas / INT
Round down a decimal number to the nearest integer.
=INT(number)
  • number - required, the real number to round down to an integer

Examples

  • =INT(3.25)

    The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns 3.

  • =INT(3.99)

    The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns 3.

  • =INT(3.01)

    The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns 3.

  • =INT(-3.1)

    The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns -4 because INT rounds down to the lower integer.

  • =INT(-3.99)

    The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns -4 because INT rounds down to the lower integer.

  • =INT(-3.01)

    The function truncates any decimal portion of a number, rounding down to the lower integer. This example returns -4 because INT rounds down to the lower integer.


Summary

The INT function is used to round a real number down to the nearest integer. It takes a real number as its argument and returns an integer result.

  • The INT function returns the integer part of a decimal number, rounding down to the nearest integer.
  • The INT function removes any fractional part of the decimal number, returning only the integer part.

Frequently Asked Questions

What is the INT function?
The INT function is a mathematical function that rounds numbers down to the nearest integer. Integer numbers are whole numbers, and do not include fractions or decimals.
How does INT work?
The INT function takes a real number as its argument. The real number is then rounded down to the nearest integer. Any fractional part of the number is discarded.
What types of numbers can I use with INT?
The INT function only works with real numbers. Examples of real numbers are:
  • 3.14159
  • -2.71828
  • 4.0

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV