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