Fix(number) returns The integer portion of number (without rounding). If number is negative, returns the negative number greater than or equal to number. : Fix « Math Functions « VBA / Excel / Access / Word






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

Fix(number) returns The integer portion of number (without rounding). If number is negative, returns the negative number greater than or equal to number.

 
Sub mathDemo5()
   Debug.Print Fix(3.14159)
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() Returns the integer portion of a number.
3.Fix(-3.14159) returns -3