Table of Contents
About
INT function in Excel is used to round down a decimal number to the nearest integer.
Function Type
Math and trigonometry
Purpose
Get the integer part of a number after rounding it down.
Return value
Number equivalent to the rounded number
Syntax
=INT(number)
Arguments
number – The number to round down as integer
Example 1
Notes
INT function always rounds down the number. To get the integer part of a negative number, use TRUNC function.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)