Microsoft KB Archive/104813

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q104813 to Microsoft KB Archive/104813 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Mac Works 3.0: Incorrect Average Function in Gradebook document

PSS ID Number: Q104813 Article last modified on 10-22-1998



====================================================================== 3.00 MACINTOSH kbother

The information in this article applies to:
- Microsoft Works for the Macintosh, version 3.0


In Microsoft Works 3.0 for the Macintosh, the Stationery includes a Gradebook spreadsheet (in Microsoft Works: Stationery: Education). The Gradebook spreadsheet has an incorrect formula.

In cell C6 of the spreadsheet, the AVERAGE function is incorrect because it includes Quiz 1 scores in the Assignments average.

This formula should read as follows:

=0.4AVERAGE(D6:G6)+ 0.6AVERAGE(H6:I6)

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 3.00 mac mwksss mwksprb documentation error doc

====================================================================== Version : 3.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.