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

William Benson vbacreations at gmail.com
Thu Dec 22 11:13:33 CST 2011


I am sure that they are losing so much money that most of their thinking
investors and auditors have abandoned and the fools who remain don't know
the difference between a balance sheet that adds up and one that doesn't.
On Dec 22, 2011 12:03 PM, "Mark Simms" <marksimms at verizon.net> wrote:

> 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.
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list