VBA/Excel/Access/Word/Math Functions/Fix
Содержание
- 1 Displaying the integer part of a number: uses the Fix function, which returns the integer portion of a value - the value without any decimal digits
- 2 Fix(- returns -3
- 3 Fix(number) returns The integer portion of number (without rounding). If number is negative, returns the negative number greater than or equal to number.
- 4 Fix() Returns the integer portion of a number.
Displaying the integer part of a number: uses the Fix function, which returns the integer portion of a value - the value without any decimal digits
<source lang="vb">
Sub GetIntegerPart()
Dim MyValue As Double Dim IntValue As Integer MyValue = 123.456 IntValue = Fix(MyValue) MsgBox IntValue
End Sub
</source>
Fix(- returns -3
<source lang="vb">
Sub mathDemo6()
Debug.Print Fix(-3.14159)
End Sub
</source>
Fix(number) returns The integer portion of number (without rounding). If number is negative, returns the negative number greater than or equal to number.
<source lang="vb">
Sub mathDemo5()
Debug.Print Fix(3.14159)
End Sub
</source>
Fix() Returns the integer portion of a number.
<source lang="vb">
Sub mathF3()
Debug.Print Fix(-9.1)
End Sub
</source>