[AccessD] My Excel project...you won't believe this one

Mark Simms marksimms at verizon.net
Thu Dec 22 11:02:31 CST 2011


Instead of using the number format to properly display the numbers,
the original developer would use the Format function to round a large series
of individual values,
 and then total-up the rounded results instead of the original values.
As you are aware, precision is likely lost in doing it this way.
Ex: .55+.55=1.1
His method would be to first "round-up" the .55 to .6:
Ex: .6+.6=1.2
In this case, the total is now "off" by almost 10% !

And...this is a vital model that helps to run the company's main processing
unit.

Wowzer indeed.






More information about the AccessD mailing list