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?
 
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
All Courses

From novice to tech pro — start learning today.