Figured out the problem -- follow_up was dimmed as an integer so it
was = 0 instead of 0.5

Thanks!

On Oct 8, 9:39*am, "Don Guillett" wrote:
I just did this and got 1

Sub rr()
cost = 1
follow_up = 0.5
x = Application.WorksheetFunction.RoundUp((cost * follow_up), 0)
MsgBox x
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...

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.