Mac Works 3.0: SSum Function Incorrectly Rounds Cell Values
  
PSS ID Number: Q127995
Article last modified on 10-22-1998
 
3.0 3.0a
 
MACINTOSH
 

======================================================================
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 3.0, and 3.0a
----------------------------------------------------------------------
 
SYMPTOMS
========
 
When you are using a Works spreadsheet, the SSum function incorrectly
totals cells formatted to show zero decimal places (rounded cells). In the
following examples,
 
   Unformatted Cells     Formatted Cells
 
   A1   14.5             A1   $14
   A2    2.25            A2    $2
   A3   =ssum(a1:a2)     A3   $17
 
if you formatted cells A1 and A2 to show zero decimal places, the sum of
A1:A2 should be 16, not 17 as shown above.
 
CAUSE
=====
 
In Works 3.x, the SSum function will individually add cell values,
including decimal places, then total the cells according to the formatting
you have chosen. In the above example, SSum comes up with 16.75 then rounds
up, rather than rounding 14.5 to 14 and 2.25 to 2 for a total of 16.
 
RESOLUTION
==========
 
Upgrading to Microsoft Works version 4.0 for the Macintosh corrects this
problem.
 
 -or-
 
For version 3.x, you need to individually round cell figures. Use the Round
function, as shown below, to correctly calculate your cell totals.
 
    Cell   Entry            Result
    A1     =round(14.5,0)   $14
    A2     =round(2.25,0)    $2
    A3     =ssum(a1:a3)     $16
 
Additional query words: 3.00 3.00a m_works math inaccurate summing,
summed
======================================================================
Keywords          : kbbuglist kbfixlist
Version           : 3.0 3.0a
Platform          : MACINTOSH
Issue type        : kbbug
=============================================================================
Copyright Microsoft Corporation 1998.