INT

The INT function in Google Sheets rounds a number down to the nearest integer that is less than or equal to it. It is commonly used when working with numerical data that needs to be truncated. Learn how to use this function effectively in our comprehensive guide.

Function Syntax and Parameters

Syntax: INT(value)

Parameters:

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

Step-by-Step Tutorial

1. Using INT with a single number:
   • Example: =INT(5.8)
   • Result: 5

Use Cases and Scenarios

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

Related Functions

No related functions available for the INT function.

Related Articles

No related articles available for the INT function.