The VBA FIX Function
VBA Fix and Int Functions
The VBA Fix function is very similar to the VBA Int function, which also returns the integer portion of a number.
The difference between these two functions is:
- The Fix function rounds both positive and negative numbers towards zero;
- The Int function rounds positive numbers towards zero and negative numbers away from zero.
Description
The VBA Fix function truncates a supplied number to an integer.
The syntax of the function is:
Fix( Number )
Where the Number argument is the number that you want the integer part of.
VBA Fix Function Examples
|
' Return the integer parts of the numbers 77.7 and -77.7
Dim int1 As Integer
Dim int2 As Integer
int1 = Fix( 77.7 )
' Now, int1 = 77 and int2 = -77
int2 = Fix( -77.7 ) |
In the above VBA code:
- The Fix function has rounded the number 77.7 to the integer 77;
- The Fix function has rounded the number -77.7 to the integer -77.
Note that the VBA Fix function rounds both positive and negative values towards zero.
VBA Fix Function Error
If the Fix function is supplied with a value that cannot be interpreted as a number, it will return the error:
Run-time error '13': Type mismatch
