Round up currency to nearest dollar

Hi experts

How can i round currency up to the full dollar amount?
Thank you
isnoend2001Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
create the CEIL function:

public function Ceil(value as double)
    Ceil = CDbl(CLng(value + 0.5))
end function


0
 
isnoend2001Author Commented:
Just what i needed
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.