Formulas > =INT()

How To Use INT() Function in Google Sheets


Rounds a number down to the nearest integer that is less than or equal to it.

Common questions about the INT Formula: 
  • What does the INT Formula do?
  • How does it work?
  • What is the syntax of the formula?

How the INT Formula Can Be Used Appropriately:
The INT formula can be used to round a numerical value down to its nearest integer or whole number. This formula can be used in financial, scientific, mathematical and engineering calculations.

How Can the INT Formula Be Commonly Mistyped:
The INT formula is most commonly mistyped when the brackets around the numerical value are forgotten.

What are Some Common Ways the INT Formula is Used Inappropriately:
The INT formula should not be used to truncate decimals. Additionally, the formula should not be used in a cell range that contains numbers and text.

What are Some Common Pitfalls when Using the INT Formula:
The INT formula should not be used when negative numbers are present. Additionally, the formula should not be used to truncate or round down the decimals after the comma.

What are Common Mistakes when Using the INT Formula:
Common mistakes when using the INT formula include mistyping the formula, entering a cell range that contains both text and numbers, and forgetting the brackets around the numerical value.

What are Common Misconceptions People Might Have with the INT Formula:
A common misconception is that the INT formula will round numbers instead of truncate them. This is not the case as the INT formula only truncates the numerical value and does not round it.

How To Actually Use INT() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the INT() formula:


Discover the INT, EVEN, and ODD functions. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

Generate a INT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.