Excel INT Function – Rounding Down Only

The Excel INT Function is one of the Excel Formulas that are absolutely necessary, when you need to make calculations or lookup values that are buried in your data or simply compare values or format them. So learning which ones to use and how to use them is imperative if you want to bump up your skill level.

Definition of the Excel INT Function

The Excel INT Function returns the Integer portion of a number. It can be used as a worksheet function and a VBA function in Excel. This will round a number DOWN to the nearest integer whole number.

Excel INT Function

SYNTAX of the INT() Function:

  • =INT(number)
  • =INT(cell)
  • The value put into the INT function, or the value in the cell it refers to, must be a valid number, otherwise you will see this error. (#VALUE!)
  • Negative numbers will round down to the next lowest number, rather than just truncating the numbers to the right of the decimal point. If you do not want this, then you may want to use the TRUNC() function instead.


  • =INT(5.23455) = 5
  • Cell A1 = 324.908:             =INT(A1) = 324
  • Cell A3 = "Text"                  =INT(A3) = #VALUE!
  • Cell A4 = -25.6547             =INT(A4) = -26
Excel INT Function

Why Would You Use The INT Function?

There are times when only whole numbers are useful to you. Rather than show the decimal values too, you can use the INT function to remove the decimals. This helps you to see only the data you need, in the format that you need it. Making your job easier and more efficient.

Share, Comment, Ask Question or Rip Me a New One!

If you liked this article, please feel free to share it on social media and comment below if have any suggestions, questions or corrections. Thank you for reading!

P.S. - Remember to sign up to the newsletter email list, so you can catch all of the new posts and learn about upcoming topic, products and/or services​.

Lyrics From Foreigner Parodied Above!  ðŸ˜‰


Joe Austin

Joe Austin is the founder of Potentials Unleashed. He is currently an IT Professional Manager in the Financial Industry and has been using computers since 1978. While mostly self-taught, he is proficient in several computing areas, such as Programming , Web Development, most Microsoft Office programs, Internet Marketing, Spyware / Malware Removal and even 3D Animation & Modeling.

Click Here to Leave a Comment Below 0 comments
%d bloggers like this: