# help me compute my grade

#### jtillman

##### New Member
I need to compute my grades.
I have a quiz average of 86 this is 20% of my final grade

I have a Midterm which is 80 this is 20 % of my grade

I have homework which is 70, this is 10% of my grade

And my final is 80, this is 30% of my grade.

Help!! I need a formula.

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Don't you just need to multiply each score by its percentage weighting, and sum the results? That gives a score out of 80 (sum of percentages) in your scenario.

It seems that a piece might be missing from your data.(if you have a 100% base to work with)...anyway as Andrew stated the calculation totals only 80%...this is how i would have set it up Were you looking for one formular to handle the entire operation?
Book1
DEFGHIJ
14Quiz%MTerm%HW%Final%Other%Total
15Ratioweight20%20%10%30%80%
16
18
19Extended17.216724064.2
Sheet1

hope this helps
pll

Where's the other 20%?
The above scores only account for 80% to your credit. I hope this isn't math class.

Replies
5
Views
308
Replies
3
Views
341
Replies
2
Views
298
Replies
1
Views
170
Replies
4
Views
482

1,219,977
Messages
6,151,238
Members
451,019
Latest member
cichli_04

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back