On Mon, 19 May 2008 10:40:56 -0700 JOE Conner wrote: > Johnny Rosenberg wrote: > > 2008/5/19 TechAdmin @ VibrantLivingMinistries < > > [EMAIL PROTECTED]>: > > > <<Big SNIP>> > > Why? Because the formula in A3 now calculates A1+A2 as they are > > shown. NOT 4,4+5,4 any more, but rather 4+5. > > Still everything is rounded to the nearest integer, but since A3 is > > calculated differently, this is how things are rounded: > > 5,4___5 > > 4,4___4 > > 9,0___9 (since A3=A1 as shown + A2 as shown = 5+4 = 9,0) > > > > So if you want to keep all the decimals, even those which are not > > shown in each cell, the "Precision as shown" check box should NOT be > > ticked. > > > > Or in other words: The "Precision as shown" checkbox makes sure that > > all calculations are made, based on what you SEE in the cells, > > rather than what's actually in them. > > > > I don't know how to explain it better. If this isn't clear enough I > > hope someone else can explain it better. > > > > Johnny Rosenberg > > > > I think it may be used properly if you are doing accounting where you > do not want hidden approximations in the cell to influence incorrectly > such things as interest calculation. >
AFAIK most accounting is done (at least here in New Zealand) to four decimal places minimum. I like Johnny's explaination. The "Precision as shown" checkbox probably does have a practical purpose where approximate values are used, and any rounding will introduce errors. But being aware of what it does actually solves the issue because it empowers the user to decide if they want to use it or not. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
