excel vba floor function code example

Example: excel vba floor function

'VBA does NOT have a native Floor() function which is found in most
'programming languages. Floor() should round down to the next whole
'number. However, VBA does have the Fix() function which does exactly
'the same thing:
 
MsgBox Fix(5.000000000000001)     '<--displays: 5
MsgBox Fix(5.999999999999999)     '<--displays: 5
MsgBox Fix(5.000000000000000)     '<--displays: 5
  
'Note: This method is much faster than using the RoundDown() function.