incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 121281] New: spreadsheet total in error
Date Fri, 26 Oct 2012 17:49:25 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=121281

          Priority: P3
            Bug ID: 121281
          Assignee: ooo-issues@incubator.apache.org
           Summary: spreadsheet total in error
          Severity: normal
        Issue Type: DEFECT
        Difficulty: ---
    Classification: Application
                OS: All
          Reporter: healthfood@telus.net
          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.

Mime
View raw message