Fix(-3.14159) returns -3 : Fix « Math Functions « VBA / Excel / Access / Word

Fix(-3.14159) returns -3

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