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.4*AVERAGE(D6:G6)+ 0.6*AVERAGE(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.