INT
The INT function rounds a number down to the nearest integer, truncating the decimal part of the number.
Syntax 🔗
=INT(number)
number | The number you want to truncate to the nearest integer. |
About INT 🔗
When you need to quickly get rid of the decimal part of a number and focus solely on the whole number component, the INT function in Excel comes to your aid. It simply chops off the decimals, leaving you with an integer value. This function proves handy in various scenarios where you require precise whole number results without any rounding up considerations.
Examples 🔗
If you have a number 5.67 and wanted to get the integer part only, you would use the INT function like this: =INT(5.67), which will output 5.
Suppose you have a list of numbers in cells A1 to A5, and you want to extract the integer part for each number. You can use the formula =INT(A1) and drag it down to A5 to get the integer parts of all numbers.
For a negative number like -8.9, the INT function will return -9 as it always rounds towards zero.
Notes 🔗
The INT function always truncates the decimal part towards zero. It does not perform rounding like the ROUND or ROUNDDOWN functions. Ensure you consider the direction in which the decimals are getting truncated when using negative numbers with the INT function.
Questions 🔗
While the INT function simply truncates towards zero, removing the decimal part entirely, the ROUND function rounds a number to a specified number of digits, with options for rounding up or down depending on the digit after the specified decimal place.
Can the INT function handle negative numbers?Yes, the INT function can handle negative numbers. It truncates the decimal part towards zero, so negative numbers are rounded towards negative infinity.
Is there an equivalent function in Excel that rounds a number to the nearest integer instead of truncating?Yes, if you want to round a number to the nearest integer instead of truncating, you can use the ROUND function with a second argument of 0. This will round to the nearest whole number.