Excel Formula
 

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.
--
larry

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"larryhershman" wrote in message
...
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.
--
larry

Excel Formula
 

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

"larryhershman" wrote:

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.
--
larry

Excel Formula
 

Assuming the marks are in A9:F9

In G9 enter =AVERAGE(A9:F9)

Don't know what you're trying to do with the InsertNameCreate

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/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Sun, 2 Jul 2006 08:34:01 -0700, TAMA help <TAMA
wrote:

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

"larryhershman" wrote:

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.
--
larry

Gord Dibben MS Excel MVP