+ Reply to Thread
Results 1 to 4 of 4

formula to come up with overall scores for student's 4 exam's

  1. 03-04-2008, 09:19 PM #1
    Colsey
    Colsey is offline
    Registered User
    Join Date
    03-04-2008
    Posts
    3

    formula to come up with overall scores for student's 4 exam's

    I'm trying to create a formula to come up with overall scores for student's 4 exam's. The first three exams were worth 20% each and the last exam was worth 40%. I'm dying here. Any help would be awsome, thanks
    Reply With QuoteRegister To Reply
  2. 03-04-2008, 09:26 PM #2
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    If your four scores are in A1,A2,A3,A4 with A4 the 40%

    =(A1+A2+A3+A4+A4)/5

    should do it.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
  3. 03-04-2008, 09:31 PM #3
    Colsey
    Colsey is offline
    Registered User
    Join Date
    03-04-2008
    Posts
    3

    re

    Thank you so much.
    Reply With QuoteRegister To Reply
  4. 03-04-2008, 09:37 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Colsey, to avoid your next thread being closed, please choose a title that decribes your problem.

    Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1