December 4, 2020

How to get the Integer part from a decimal number in Google Sheet

INT Function is used when you would like to get the integer portion of a number in both Excel & Google Sheet.

=INT(number)
Input Arguments :
  • number – the decimal number for which you want to get the integer value.

In below example in cell B2 we got the integer part by using INT function on the decimal value in cell A2.

INT function can be used with a negative decimal number as well. But in that case it rounds down the number. As you can see in the below example that you got the integer number in B2 which is lower than the given decimal number in A2.

Leave a Reply

Your email address will not be published. Required fields are marked *