I had earlier pasted a section of the Excel sheet into an Open Office spreadsheet to confirm the problem. When confirmed, I posted my question on their forum in addition, needing a resolution before this Friday.
Remembering my initial post problem was that the spreadsheet value returned from the multiplication was ~1.65 different than that returned by a calculator (59.25 vs. 57.60).
The answer you guys gave does not change that fact--the answer is still 59.25xxxxx. But the answer that the Oo person returned did provide a way to align the calculator vs. spreadsheet as quoted below:
"Use a calculator and multiply .09*640 and you get 57.6. The actual value in the cell is .0926 rounded to four decimals. .0926*640=59.264 according to my calculator not a spreadsheet. A spreadsheet always uses the exact value no matter how you format the cell for display purposes.
Go to Tools-->Options-->Openoffice.org Calc-->Calculate and check the box "Precision as Shown" and you will get the result I show above in your spreadsheet."
Since this spreadsheet will be given to a group of folks who use calculators far more than spreadsheets, the numbers need to match that of a calculator. I do not see an option within Excel that corresponds to the 'Precision as Shown' option of Oo? Is there one or a way of getting a similar result?
|