Table of contents
TOC
Collapse the table of content
Expand the table of content

Int, Fix Functions

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Returns the integer portion of a number. SyntaxInt(number)Fix(number) The required numberargument is aDouble or any validnumeric expression. If number containsNull, Null is returned. Remarks Both Int and Fix remove the fractional part of number and return the resulting integer value. The difference between Int and Fix is that if number is negative, Int returns the first negative integer less than or equal to number, whereas Fix returns the first negative integer greater than or equal to number. For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8. Fix(number) is equivalent to:

Sgn(number) * Int(Abs(number))

Example

This example illustrates how the Int and Fix functions return integer portions of numbers. In the case of a negative number argument, the Int function returns the first negative integer less than or equal to the number; the Fix function returns the first negative integer greater than or equal to the number.

Dim MyNumber
MyNumber = Int(99.8)    ' Returns 99.
MyNumber = Fix(99.2)    ' Returns 99.

MyNumber = Int(-99.8)    ' Returns -100.
MyNumber = Fix(-99.8)    ' Returns -99.

MyNumber = Int(-99.2)    ' Returns -100.
MyNumber = Fix(-99.2)    ' Returns -99.
© 2017 Microsoft