help me compute my grade

jtillman

New Member
Joined
Oct 11, 2002
Messages
1
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.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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
17Grade86807080316
18
19Extended17.216724064.2
Sheet1


hope this helps
pll
 
L

Legacy 98055

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

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,650
Members
414,399
Latest member
Ninjee

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top