Int VBA function – How to round negative numbers down

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

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.

MsgBox Int (-9.25)
MsgBox Int (9.25)

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

Range ("A1") = Int (-9.25)
Range ("A1") = Int (9.25)
Excel VBA functions - Int VBA function
Excel VBA functions – Int VBA function

 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.

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: