Excel: Int Function

In Excel, the Int function returns the integer portion of a number.

The syntax for the Int function is:

Int( expression )

expression is a numeric expression whose integer portion is returned.

Note:

If the expression is negative, the Int function will return the first negative number that is less than or equal to the expression.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Int(A1) would return 210

=Int(A2) would return 2

=Int(A3) would return -3

=Int(-4.5) would return -5

VBA Code

The Int function can also be used in VBA code. For example:

Dim LNumber As Double

LNumber = Int(210.67)

In this example, the variable called LNumber would now contain the value of 210.