Thegr8bigmouth1
New Member
- Joined
- Nov 11, 2002
- Messages
- 4
I posted earlier today but I don't think I was very clear on what I need help with. I need to make a workbook with 5 pages 1 for each of my classes that show the way my grade for the class is broken down, all my grades I have recieved in the class, and what the grade in that class will be. For instance Psychology. In Psychology 25% of my grade is in-class/out of class assignments. 25% of my grade is made up of two papers each are worth 12.5%. And 50% of my grade is made up of two tests each being worth 25%. So in one column, lets say A, I have to put the pecentage and in the column next to it, in this case it would be B, I need to put the grade I recieved. The problem I am having is I haven't taken all my tests or wrote all my papers so I have empty columns. Lets take tests for example. On my first test I earned an 86. So 86 is 25% of my grade but I haven't taken the second test so when I factor that in most functions average a 0 into my grade. My teacher said that there is a function that I can use to get around this problem. He said that it is related to the IF function and sums based on conditions. I know I haven't described what I am doing very well but I hope someone understands and can help because I am really in a jam. Thanks