Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate grades from excell
I am trying to use excell to calculate grades for the end of the term,
however I am not sure how to do this. I am using a percentage to calculate but can not get an average score or overall score. For example I enter the grades and 20% is for exams, 30% to final exam and 50% for term assignments. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate grades from excell
Assuming your cells for Exams=A1; Final Exam=A2; Term Assig.=A3 all you need to do is: =(A1*.2)+(A2*.3)+(A3*.5) -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=528180 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate grades from excell
If the numeric grades are laid out with exam scores in A1, term assignments
in A2, and Final exam in A3, then put the 20%, 50%, and 30% in cells B1:B3, your formula would be =sumproduct(A1:A3,B1:B3) "Spring coulter" wrote: I am trying to use excell to calculate grades for the end of the term, however I am not sure how to do this. I am using a percentage to calculate but can not get an average score or overall score. For example I enter the grades and 20% is for exams, 30% to final exam and 50% for term assignments. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate grades from excell
Also checkout:
http://office.microsoft.com/en-us/te...455541033.aspx -- Gary's Student "Spring coulter" wrote: I am trying to use excell to calculate grades for the end of the term, however I am not sure how to do this. I am using a percentage to calculate but can not get an average score or overall score. For example I enter the grades and 20% is for exams, 30% to final exam and 50% for term assignments. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do i calculate i in excell | Excel Discussion (Misc queries) | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
students grades, formulae to calculate what grade is needed based. | Excel Worksheet Functions | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
How do calculate grades in Excel? | Excel Worksheet Functions |