× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. March 2013

Re: Round up a number to 4 decimal positions

On Wed, Mar 20, 2013 at 1:19 PM, Michael Schutte <mschutte369@xxxxxxxxx> wrote:
I'm apparently missing something. The ROUNDUP function in EXCEL take the
value of .0142 and make it .0142, and the value of .0142000001 will round
up to .0143. If the requirement is to mock the EXCEL ROUNDUP function then
you will need to add .0000999999 or however many nines that are needed
to fill in the rest of the decimal points. 4 zeros followed by all 9s.
That away anything greater than .0142 will be rounded up to .0143

What you are missing is that I said exactly that.

On Wed, Mar 20, 2013 at 12:49 PM, John Yeung <gallium.arsenide@xxxxxxxxx>wrote:

Well, adding 0.00005 and then doing a normal round (half-adjust) is
clearly wrong:

If the true value to be rounded happens to be 0.0142 exactly, then
your algorithm produces 0.0143.

The suggestions to add whatever is JUST smaller than 0.00005 and then
round normally; or to add JUST less than 0.0001 and then truncate; are
the right ones.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.