How to use INT Google Sheets formula?

The syntax for the INT formula is =INT(value), it has 1 required parameter.

INT

The INT 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:

=INT(value)

Parameters:

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 the INT 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 non-numeric 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.

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 the places 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.

INT