# MS Excel: INT Function (WS, VBA)

Learn how to use the Excel **INT function** with syntax and examples.

## Description

The Microsoft Excel **INT function** returns the integer portion of a number.

## Syntax

The syntax for the Microsoft Excel **INT function** is:

INT( expression )

### Parameters or Arguments

*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

The **INT function** can be used in the following versions of Microsoft Excel:

- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

## Type of Excel Function

The **INT function** can be used in Microsoft Excel as the following type of function:

- Worksheet function (WS)
- VBA function (VBA)

## Example (as Worksheet Function)

Let's look at some Excel INT function examples and explore how to use the **INT function** as a worksheet function in Microsoft Excel:

Based on the spreadsheet above, the following Excel **INT examples** would return:

=INT(A1) | would return 210 |

=INT(A2) | would return 2 |

=INT(A3) | would return -3 |

=INT(-4.5) | would return -5 |

## Example (as VBA Function)

The **INT function** can also be used in VBA code in Microsoft Excel.

Let's look at some Excel INT function examples and explore how to use the **INT function** in Excel VBA code:

Dim LNumber As Double LNumber = Int(210.67)

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