INT function

Excel INT Function is a simple yet useful mathematical function that helps you round down a number to the nearest integer. In simpler terms, it takes a decimal number and converts it into a whole number by removing the decimal part. This can be handy for scenarios where you need whole numbers and don’t want to round up or round to the nearest integer.




numberThe number you want to round down to the nearest integer.

How to Use

Let’s explore how to use the INT function with a few examples:

Example 1: Basic usage

In this case, the INT function will round down 7.8 to the nearest integer, which is 7.

Example 2: Handling negative numbers

Here, the function will round down -5.4 to the nearest integer, which is -6.

Example 3: Rounding a whole number

Even if you provide a whole number, the INT function will not change it. It will return 42 as it is.

Example 4: Using the INT function with other formulas

You can also use the INT function in combination with other functions, like SUM. Here, it will first calculate the sum of 3.5 and 4.2, which is 7.7, and then round it down to 7 using the INT function.

Example 5: Handling optional arguments

When an argument is enclosed in square brackets and marked as (Optional), it means you can omit it. In this case, the INT function will still work with just the number provided, rounding down 9.9 to 9.

Excel’s INT function is a helpful tool for quickly converting decimal numbers to integers. Whether you’re working with financial data, grades, or any situation where whole numbers matter, INT simplifies the process.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.