Excel macro: how to use floor function in macro code

[georgemathew46]

Hi,

i am trying to get a floor value in excel macro.

eg:
assume x=20
(x/9)=2.222
but i want to print as 3 which can be accomplished using floor function.
but am not able to use excel inbuilt functions in macro.

like floor(x/9) which throws me a error: function not found.

Please help me out ..

 

[Michael M]

x/9 will give 2.222, but the Floor function will give you 2 not 3.
To get 3 you will need the Ceiling function

Sub MM1()
Dim x As Integer
x = 20
ans = Application.Floor(x / 9, 1)
MsgBox ans
End Sub



Sub MM2()
Dim x As Integer
x = 20
ans = Application.Ceiling(x / 9, 1)
MsgBox ans
End Sub

 

[georgemathew46]

Thanks .... Works like a Charm..

 

[Michael M]

Glad it worked...