Excel Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new at excell 2003. I am working on a spread sheet and I cannot find the
formula I need.
My question is based on the following information:

Homework average (94) = 15%, Project average (95) = 40%, and Test average =
(45%). What is the Final grade?

I want to thank you advance for your help.
 
One way ..

Assuming the marks and weighted %
are in B2:C4, as below:
(a mark of 80 is assumed for "Test average")

94 15%
95 40%
80 45%

Put in B5: =SUMPRODUCT(B2:B4,C2:C4)

For the sample data, B5 will return: 88.1
 
i am also new at excell my qt. is i have 6 student which is A through F
there average is 92 96 61 86 79 84 . When i average them up and come out with
498 now , i need to get the sum of in l cells A9, B9 , i go to my task bar
to insert then i select name , create , left column enter okey it does not
show some of n at cell A9 , b9 , CAN YOU HELP
 
Assuming the marks are in A9:F9

In G9 enter =AVERAGE(A9:F9)

Don't know what you're trying to do with the Insert>Name>Create

By the way....it is not a task bar.........it is a worksheet menu.

Since you are new, you may benefit from looking at some sites which help explain
a bit about how to use Excel.

Some tutorial sites for basics of Excel........

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/training/CR061831141033.aspx


Gord Dibben MS Excel MVP

On Sun, 2 Jul 2006 08:34:01 -0700, TAMA help <TAMA
i am also new at excell my qt. is i have 6 student which is A through F
there average is 92 96 61 86 79 84 . When i average them up and come out with
498 now , i need to get the sum of in l cells A9, B9 , i go to my task bar
to insert then i select name , create , left column enter okey it does not
show some of n at cell A9 , b9 , CAN YOU HELP
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top