Round up currency to nearest dollar

Hi experts

How can i round currency up to the full dollar amount?
Thank you
Who is Participating?
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

isnoend2001Author Commented:
Just what i needed
Thank you
All Courses

From novice to tech pro — start learning today.