11 Feb 15:37 2016

### Re: Currency calculations [was: Avery 8167 label printing]

Virgil Arrington <cuyfalls <at> hotmail.com>

2016-02-11 14:37:05 GMT

2016-02-11 14:37:05 GMT

Thanks for the tip, but back in 1989 when this was all happening, I'm not sure that my DOS spreadsheet even had the ability to display numbers as "currency". I certainly made no attempt to do so, even if it were possible. They were just numbers and, yes, integers, and no, the spreadsheet didn't get 28 divided by 7 correct. I have learned, however, as you point out, that how numbers are displayed is not the same as what they are. For example, you can't "round" a number in a spreadsheet by simply reducing the number of decimal places displayed in a cell. The underlying number remains unrounded and further calculations with it might produce undesired results. When working with currency, I've developed the habit of probably overusing the the " <at> round" function at each step of a complex calculation just to ensure desired results. Virgil On 02/11/2016 04:16 AM, Brian Barker wrote: > At 15:18 10/02/2016 -0500, Virgil Arrington wrote: >> About 25 years ago, I was the treasurer of my children's preschool. I >> created a spreadsheet to calculate paychecks, and I found that the >> paycheck was consistently off by .01 (a penny). It drove me nuts. As >> it turned out, one part of the calculation required the division of >> 28 by 7, which every third grader knows is 4. Well, my spreadsheet >> gave an answer of 3.9999999999_. By itself, it wasn't a big problem, >> but later in the chain of operations, the 3.99999_ produced a result >> that rounded(Continue reading)*down*to the nearest penny instead of*up*, which it >> would have done if the 28/7 had resulted in 4 instead of 3.9999. I >> complained to a computer friend of mine who tried to explain that the >> computer's answer was more "precise" than my mental math of 28/7=4. I