Accountants add 5 to the digit to the right of the round which forces what you want.
To round pennies, add 0.005 to the value, and it will round up. If you want to be super sneaky, use 0.00499 so that exact numbers don't round, but 1/100 Cents will. (ROUND($$value + .00499, 2)) $$value = 2.00 > 2.00 $$value = 2.00001 > 3.00 , "Dan Goldberg" <[EMAIL PROTECTED]> wrote: >Doe anybody know a function to round a number up. I have looked at the round >functions but they only round to the closest number. > > >Dan Goldberg > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
