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
- Examples of using
INTformula not working?
- Similar formulas to
INT formula with the syntax shown below, it has 1 required parameter:
- value (required):
The value to be rounded down to the nearest integer.
ExamplesHere are a few example use cases that explain how to use the
INT formula in Google Sheets.
Simplifying large numbers
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
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.
INT not working? Here are some common mistakes people make when using the
INT Google Sheets Formula:
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:
ROUNDformula 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
placesparameter is not specified, the formula rounds to the nearest integer.
CEILINGfunction 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.
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.
TRUNCformula 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.
MODfunction 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.
You can learn more about the
INT Google Sheets function on Google Support.