Excel Function: INT

puneet-gogia-excel-champs

- Written by Puneet

INT returns the integer part of a decimal number. In simple words, it rounds down the specified number by removing its decimals and returns only the whole number (number without fractions, or decimals).

int-function

Syntax

INT(number)

Arguments

  • number: Number you want to round down to the nearest integer.

Example

In the example below, we have a number with four decimals and when you use the INT function and specify the values that you have in the cell B1, it returns the same number with but without decimals.

excel-int-function-example-1

So, where you have 101.4868 in the original value, INT returns 101 in the result after removing the decimals.

Now in the real world, INT is super useful, and one of the examples of it is when you need to remove time from a date and time value.

excel-int-function-seperate-date

And in the same way, you can use it to remove the date from a date and time value, as we have used in the example below.

excel-int-function-separate-time

sample-file.xlsx

Important Points

  1. It will round down both positive and negative numbers. But when you round a negative number, it will round it away from zero. So, when you round -3.9, it will return 4 in the result.
  2. You get an #REF! error if the number you have specified is not valid, and an #VALUE! Error if you specify a text instead of a number.
Last Updated: June 22, 2023