Microsoft KB Archive/104813

Mac Works 3.0: Incorrect Average Function in Gradebook document

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

3.0

MACINTOSH

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

= SUMMARY =

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.