Goran
Goran
Programming language:VBA
2021-02-18 00:25:58
0
Q:

excel vba floor function

Jody
Jody
Code: VBA
2021-02-18 00:29:55 
'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.
4

Tags

Related

New to Communities?

Join the community