View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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.