INT

The INT function in Google Sheets rounds a number down to the nearest integer that is less than or equal to it. It's commonly used when working with numerical data that needs to be truncated toward negative infinity. Dive into our comprehensive guide to master its application.

Parameters

• value: The number to be rounded down to the nearest integer.

Step-by-Step Tutorial

1. Using INT with a positive decimal:

   • Example: =INT(5.8)
   • Result: 5

2. Using INT with a negative decimal:

   • Example: =INT(-5.8)
   • Result: -6

Use Cases and Scenarios

1. Truncate Values: Round down decimal values to the nearest whole number for reporting.
2. Floor Calculations: Ensure resulting values are always less than or equal to the original number.
3. Financial Calculations: Simplify calculations by removing decimal places from currency values.

Related Functions

• ROUND: Rounds a number to a specified number of decimal places.
• ROUNDDOWN: Rounds a number to a specified number of decimal places, always rounding toward zero.
• TRUNC: Truncates a number to a specified number of significant digits.

Related Articles

No related articles available for the INT function.