The Excel INT function rounds a number down to the nearest integer value. It simply returns the integer portion of a decimal number.
You can use Excel INT function when you want to remove the decimals and return the integer part of a decimal number. But note, as the function rounds a number down to the next lowest integer value, a negative number becomes more negative.
For example, INT (-13.27) would returns -14.
- number: the number you want to round down to the nearest integer.
Examples: Excel INT Function
Let’s have a look at below example. In the following screenshot, the INT function is applied to different type of numbers.
As you can see in the above example, INT function always rounds down. Positive numbers round down towards 0 and negative number rounds down away form 0.
Extract Date & Time from Date-Time Stamp
You can also use INT function to extract either date or time from date-time stamp.
Since Excel store date and time as serial number, the integer portion represents the date and time is represented by decimal value.
When INT function is supplied with the serial number of date and time, the decimal portion is ignored by the function to return date only in cell. Later when you subtract the returned result from the actual value, you get the decimal part that represent the time value.
Tip: Use custom Date/Time formatting to change the output in Excel valid date & time format.
Additional Notes: –
- Use TRUNC function if you wish to return the exact integer value of both negative and positive numbers.
- INT function always return the integer part of a decimal value after rounding down.
- If a supplied number is positive, it rounds down a number towards 0.
- If a supplied number is negative, it rounds down away from 0
Excel INT Function: Video Tutorial