View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lecoughlin@gmail.com is offline
external usenet poster
 
Posts: 8
Default RoundUp not working in VBA

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.