Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104813

From BetaArchive Wiki

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.