rounddown in vba

[greegan]

I've done searches for this but I seem to only find formulas for spreadsheets and not vba.

I need the following
C = (I - (CPPx / P)) * CPPd
and it works... without the rounding...
to round down... I thought this would work
C = (I - rounddown(CPPx / P, 2)) * CPPd
but it gives me a Sub or Function not defined error.

Thank you

-- g

 

[p45cal]

TRY
C = (I - Application.RoundDown(CPPx / P, 2)) * CPPd
or
C = (I - WorksheetFunction.RoundDown(CPPx / P, 2)) * CPPd

 

[greegan]

Thank you both of you for your answers. Sorry for the late reply.
I used the first one and it worked great.

-- g