From: JOE Conner [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 10:41 AM To: [email protected] Subject: Re: [users] Small problem with Calc.
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 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. This makes it plain as day for me, thank you. Elchanan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
