Author: Oscar Cronquist Article last updated on August 29, 2018

The INT function removes the decimals if the numeric value is above 0 (zero) and returns a negative integer less than or equal to the given argument.

The image above demonstrates how the INT function works. The fractional part of a positive number is removed leaving only the positive integer, example: 10.9 => 10, however, a negative number, example -10.3 is converted to the negative integer that is less than or equal to the argument. -10.3 => -11.

Excel Function VBA Syntax

Int ( number )

Arguments

number Required. Is a Double or any valid numeric expression. If number is 0 (zero) then 0 (zero) is returned.

Comments

I used the following macro to show how the INT function behaves with different arguments.

Sub Macro1()
   For Each cell In Range("B3:B12")
       cell.Offset(, 1) = Int(cell.Value)
    Next cell
End Sub

INT function examples

test
Customize Excel maze
Terry wants to make a different sized maze and I think that is a great idea. Perhaps you remember that I […]
test
Find numbers in sum [UDF]
This article describes how to find a sum from a range of numbers using a user defined function. Let´s see […]
test
Find positive and negative amounts that net to zero [UDF]
Question:I would like to reduce the number of open items by identifying positive and negative amounts that net to zero […]
test
How to copy every n-th row from a list
This article demonstrates a formula and a VBA macro that returns every n-th row from a given cell range. The […]
test
How to use the INT function [VBA]
The INT function removes the decimals if the numeric value is above 0 (zero) and returns a negative integer less than […]

Excel VBA Reference

This extensive vba reference list provides detailed information including syntax, arguments, return values, and examples for Visual Basic for Applications.