https://issues.apache.org/ooo/show_bug.cgi?id=121281
Priority: P3
Bug ID: 121281
Assignee: [email protected]
Summary: spreadsheet total in error
Severity: normal
Issue Type: DEFECT
Difficulty: ---
Classification: Application
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.1
Component: formatting
Product: spreadsheet
I do not know if I am on the correct forum for reporting this or IF I have
selected the correct version. I don't know if this is the correct place for
asking for help but I will try. I am having a wee bit of trouble with my
spreadsheet. All the formulas seem to be working but once in a while, and only
SOMETIMES the total is out by 1 cent. I am sending you a document for your
review.
On line one cell (D1) I have the amount I am working with $3,246.33.
Line 4 through 9 are all percentages of this number
I have formulated it so Line 9 cell (D9) is not included in the total of lines
4-9 so my total of D4:D8 = $648.27 which is CORRECT
My PROBLEM is when I use a formula to add D9:D11 my answer on cell D11 says
$811.58 BUT if you just look at the numbers you will see it is out by one
penny.
If I add that on a calculator or my in my head it should be $811.59 not
$811.58. HELP!
--
You are receiving this mail because:
You are the assignee for the bug.
