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.