I have a Microsoft Excel question.

I'm usually really good with computers and figuring things out on my own, but I cannot figure out the correct formula for the life of me! Please help.

I have to enter a set of random grades for a homework column and a test column. I knew how to find the average of the scores for both columns, but when it comes to finding the "final grade," I don't know how to tell excel that 'Homework' is worth 40% and Tests are 60%... it just averages them out 50:50 when i do it.

Can anyone help? Please.

Question

I have a Microsoft Excel question.

I'm usually really good with computers and figuring things out on my own, but I cannot figure out the correct formula for the life of me! Please help.

I have to enter a set of random grades for a homework column and a test column. I knew how to find the average of the scores for both columns, but when it comes to finding the "final grade," I don't know how to tell excel that 'Homework' is worth 40% and Tests are 60%... it just averages them out 50:50 when i do it.

Can anyone help? Please.

anonymous · Answer

You're looking for some weighted average function. This might be of some use to you: http://support.microsoft.com/kb/214049