INT
TheINT
formula rounds a given value down to the nearest integer. This formula is often used to simplify large numbers or to convert decimal values to integers. The formula takes a single parameter, the value to be rounded down. If the value is already an integer, the formula will return the same value. If the value is a decimal, the formula will round down to the nearest integer.
 How to use
INT
formula?  Examples of using
INT
formula INT
formula not working? Similar formulas to
INT
Usage
Use the INT
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to be rounded down to the nearest integer.
Examples
Here are a few example use cases that explain how to use theINT
formula in Google Sheets.
Simplifying large numbers
The INT
formula can be used to simplify large numbers by rounding them down to the nearest integer. For example, if you have a number like 1,234,567.89, you can use the INT
formula to round it down to 1,234,567.
Converting decimal values to integers
The INT
formula can also be used to convert decimal values to integers. For example, if you have a decimal value like 3.14159, you can use the INT
formula to convert it to the integer value 3.
Common Mistakes
INT
not working? Here are some common mistakes people make when using the INT
Google Sheets Formula:
Missing argument
The INT formula requires at least one argument, which is the value to be rounded down to the nearest integer. If you forget to include this argument, you will receive an error.
Incorrect argument type
The INT formula requires a numeric value as its argument. If you provide it with a nonnumeric value, you will receive an error.
Rounding down to the wrong integer
The INT formula always rounds down to the nearest integer. If you want to round to the nearest even integer, use the EVEN formula instead.
Related Formulas
The following functions are similar to INT
or are often used with it in a formula:

ROUND
The
ROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If theplaces
parameter is not specified, the formula rounds to the nearest integer. 
CEILING
The
CEILING
function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments. 
FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

TRUNC
The
TRUNC
formula returns a number truncated to a specific number of decimal places. It is commonly used to remove decimal places from a number without rounding. This formula is often used in financial calculations and data analysis where exact values are important. 
MOD
The
MOD
function returns the remainder of a division operation. It takes two numeric inputs: the dividend and divisor. The result will be the remainder after the dividend has been divided by the divisor. This function is often used in financial and accounting calculations.
Learn More
You can learn more about the INT
Google Sheets function on Google Support.