Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Grades
Hello, I am an Excel newbie, and for some reason my wife has prevailed on me to help her build a spreadsheet for her middle shool grades. Here is the problem: She wants to calculated weighted averages, which is easy enough (in her system, homework is 25%, quizzes 35%, and 1 test at 40%). The problem is that she wants the spreadsheet to recalculate automatically if a test is left blank. Since there is only one test, excel will need to re-weight the averages. So far, I have been doing it manually for the kids who miss a test, but I want to use the IF (ISBLANK) syntax to automate everything. Can anyone help me? Thanks, Mike -- Michael L ------------------------------------------------------------------------ Michael L's Profile: http://www.excelforum.com/member.php...o&userid=27787 View this thread: http://www.excelforum.com/showthread...hreadid=472970 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average student grades | New Users to Excel | |||
Counting number of grades in a row | Excel Worksheet Functions | |||
Do any of the Grade book templates using Excel average grades? | Excel Discussion (Misc queries) | |||
Vlookup student grades | Excel Discussion (Misc queries) | |||
Converting Letter Grades to Numeric | Excel Worksheet Functions |