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.
Excel INT Function
SYNTAX of the INT() Function:
- 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
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! 😉