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.

Questions

How does the INT function differ from the ROUND function?

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.

Related functions

ROUND
ROUNDDOWN
ROUNDUP
TRUNC
CEILING
FLOOR