INT
The INT function rounds a number down to the nearest integer by truncating the decimal part. It always rounds towards zero. Use this function to discard the fractional part of a number.
Syntax 🔗
=INT(number)
number | The number you want to truncate to the nearest integer. |
About INT 🔗
Use the INT function in Excel to convert a number to its integer part by removing the decimal portion. This function is useful when you need whole number results without rounding.
Examples 🔗
If you have a number 5.67 and want to get the integer part only, use the INT function like this: =INT(5.67). It 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. 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 truncates the decimal part towards zero. It does not round numbers like the ROUND or ROUNDDOWN functions. Be mindful of how decimals are truncated, especially with negative numbers using 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.