 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Excel 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.  Signaturelarry 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 Signature-- Rgds Max xl 97 --- GMT+8, 1? 22' N 103? 45' E xdemechanik <at>yahoo<dot>com ---- > I am new at excell 2003. I am working on a spread sheet and I cannot find the > formula I need. [quoted text clipped - 6 lines] > -- > larry 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 > I am new at excell 2003. I am working on a spread sheet and I cannot find the > formula I need. [quoted text clipped - 4 lines] > > I want to thank you advance for your 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 >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 [quoted text clipped - 10 lines] >> >> I want to thank you advance for your help. Gord Dibben MS Excel MVP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.