RoundUp not working in VBA
It's working here when cost and follow_up are defined before X.
You may want to add a debug.print
Debug.print Cost, Follow_UP
before the X =
to see what you really have.
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
" wrote:
Can anyone provide insight into why the following is not working?
x = Application.WorksheetFunction.RoundUp((cost * follow_up), 0)
cost = 1
follow_up = 0.5
but x is coming out as 0 instead of 1
Thanks.
|