Fix() Returns the integer portion of a number. : Fix « Math Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Math Functions
  3. Fix

Fix() Returns the integer portion of a number.

 
Sub mathF3()
    Debug.Print Fix(-9.1)
End Sub








Related examples in the same category

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(number) returns The integer portion of number (without rounding). If number is negative, returns the negative number greater than or equal to number.
3.Fix(-3.14159) returns -3