How to Use the INT Function in Excel

When working with Excel or Google Sheets, you may often find the need to round a number down to its closest integer. Both Excel and Google Sheets provide the INT function to facilitate this.

Function Overview

The INT function is designed to round a number down to the nearest whole number by stripping away its decimal component. This converts any numerical value—positive or negative—into a simple integer.

Syntax

The formula for the INT function is straightforward:

INT(number)

• number: This is the numeric value that you wish to round down to the nearest integer.

Examples

Example 1: Basic Usage

Consider a scenario where you have the number 5.7 in cell A1, and you need to round it downwards. The formula to use would be:

Applying the INT function returns 5, as it rounds down the number 5.7 to the nearest whole number.

Example 2: Rounding Negative Numbers

If you are dealing with a negative number such as -3.4 in cell A1, and you need to round it downward, use:

Here, the result is -4 because the INT function rounds -3.4 down to -4.

Example 3: Combining with Other Functions

The INT function can also be integrated with other formulas. For instance, to calculate the sum of two numbers and then round down the result, you would proceed as follows:

The sum of 6.8 and 4.2 is 11, which is then rounded down to 11 by the INT function, maintaining it as an integer.

These examples illustrate how the INT function serves as a practical tool for rounding down numbers to their nearest integer in both Excel and Google Sheets.

More information: https://support.microsoft.com/en-us/office/int-function-a6c4af9e-356d-4369-ab6a-cb1fd9d343ef