Functions in Excel macro

[Srikanth Ganesan]

Hello,

I am trying to write an Excel macro. I want to use the following
functions that are available in Excel. Please let me know what are the
corresponding VB functions/syntax for the macro:
Excel Functions:
MOD(n,k)
Floor(n,k)
Ceiling(n,k)

Thanks

Srikanth

 

[Norman Jones]

Hi Srikanth

You can use the Floor and Ceiling worksheet functions in VBA thus:

Res = Application.WorksheetFunction.Floor(n, k)
Res = Application.WorksheetFunction.Ceiling(n, k)

VBA has its own Mod operator, the syntax being:

Res = n Mod k

 

[Jim Cone]

Srikanth,

x = n Mod k
x = WorksheetFunction.Floor(n, k)
x = WorksheetFunction.Ceiling(n, k)

Regards,
Jim Cone
San Francisco, CA