**1. Int VBA function – Description**

The **Int VBA **function is used to round numbers that have decimal places to integers. The Int function, in comparision to the **Round** function, does not require entering additional arguments. The result will always be an integer. An important information is that for negative numbers, the VBA Int function rounds a number **further from zero**. For example, the number -4.5 will be rounded to -5. If you want to round negative numbers up to zero, you should use the **VBA Fix** function .

**2. VBA Int function – Syntax**

1 2 |
'officeinside.org Int (Number) |

**Number** : The number that you want to round.

**Function return** : Number / integer value.

**3. VBA Int function – Example**

How to use the **Int ** functions in VBA Excel? Examples of using the Fix function in the VisualBasic Editor are listed below.

**Example 1** : Example of using the Int VBA function – result in the MsgBox window.

1 2 3 |
'officeinside.org MsgBox Int (-9.25) MsgBox Int (9.25) |

**Example 2** : VBA Int – example of a function – result in an Excel spreadsheet.

1 2 3 |
'officeinside.org Range ("A1") = Int (-9.25) Range ("A1") = Int (9.25) |

### **4. VB Int function – Additional information**

- The function does not require entering additional arguments.
- In the case of negative numbers, the function rounds further away from zero.

**5. Int ****VisualBasic function – Where to use?**

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.

The article is part of the list of VBA Excel functions. A list of all VBA functions can be found at this address: Excel VBA functions.