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
| The information in this article applies to: |
| - Microsoft Works for the Macintosh, version 3.0 |
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.
