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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
