INT Function in Google Sheet

  • Reading time:2 mins read
  • Post category:Functions
  • Post comments:0 Comments

Google Sheets provides a variety of functions to perform rounding operations on numbers, INT Function being one of them.

Using INT Function you can very easily round down decimals to nearest Integer values. Lets cover all the necessary components and gain complete understanding of dynamics of INT Function.

Purpose of INT Function

INT Function rounds down the number to nearest integer that is less than or equal to it.

To use it simply type “=INT(” place the number within and close the bracket. Another ways is to click on the function dropdown in the Toolbar.

INT Function - Google Sheets

Syntax and Parameter Definition

=INT(value)
  1. value: Any static number/cell reference which needs to be rounded down to nearest integer.

Note:

  1. INT Function only accepts numerical input.
  2. Any form of non-numerical input(like “abc”, “xyz” etc) will result in an “#VALUE!” error.
  3. INT is fundamentally different from both CEIL(significance of -1) and ROUNDDOWN(places is set to zero)
  4. It’s similar to FLOOR function with a factor of 1 {=FLOOR ( Value ,1)}.

Expected Output

INT Function returns the nearest integer(as a whole number), less than or equal to the supplied value input. Below are some examples to help us understand this concept better.

INT Function - Google Sheets

An important point to notice here is the treatment of negative decimal numbers. As visible the negtive decimal numbers are rounded up to higher level of integer (-10.2 becomes -11) in absolute terms. But yes -11 is less than -10.2, hence we are still very much consistent with then definition of INT function here.

Visual Demonstration of INT

Before we end here is a simple visual demonstration of INT Function

INT Function - Google Sheets - Video

That’s it on this topic. Keep browsing SheetsInfo for more such useful information 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply