How to use Excel INT Function to Remove Decimal Places

Excel INT function which is used to rounds a number down to the nearest integer. The Excel INT function is located in the Math & Trig category in Excel. If you have a large list of numbers in which you have lot of decimal places then you have easily remove then with the help of INF function in Excel.

Excel INT Function

During working on large worksheet data sometime you have a large list of numbers including decimal places. There are two ways to quickly remove the decimal places from your list. You can use Excel INT function used to returns the integer part of a decimal number by rounding down to the integer.

Syntax of INT Function in Excel

INT(number)

Arguments

Number: Number is an required argument of INT function in Excel. It is the real number which you want to round down to an integer.

Must Read: 5 Ways to use SUM Function in MS Excel

There are lot of ways from which you can rounding the numbers but INT function is too much useful and suitable from all other methods. INT function always round a number down to the next lowest integer during removing the decimal portion of given number.

How to use Excel INT Function to Remove Decimal Places

For eg:

(a) If you want to round down any positive number (10.8) with the help of INT function. You have to put the given function in any cell to get the result. =INT(10.8).

When you press enter you will get 10 decimal places are removed from the given number. You can also use cell address of any specific cell which number you want to round down.

(b) To round down any negative number (-10.8) using INT function type the given function
=INT(-10.8).

Now press enter you will get -11 as a result. Decimal places removed from the given number and negative numbers become more negative.

I hope after reading this guide you can easily use Excel INT Function to and easily round down the given number and remove unwanted decimal places. If you have any suggestion or query regarding this article then please let me know in the comment box.

Leave a Reply

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