Microsoft KB Archive/127995

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.