Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Sullivan
 
Posts: n/a
Default Formula for determing average based on weighting

What is the formula for determining the following: If you have an 84 average
that counts as 60% of a grade (school); and you have 91 average that counts
as 30% of a grade' and you have 85 average that counts as 10% of your grade,
what is the formula to determine what your average of all 3 is, to arrive at
a final grade point average?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Formula for determing average based on weighting

Hi!

Try this:

A1 = 84
A2 = 91
A3 = 85

B1 = 0.6
B2 = 0.3
B3 = 0.1

=SUMPRODUCT(A1:A3,B1:B3)

Biff

"John Sullivan" wrote in message
...
What is the formula for determining the following: If you have an 84
average
that counts as 60% of a grade (school); and you have 91 average that
counts
as 30% of a grade' and you have 85 average that counts as 10% of your
grade,
what is the formula to determine what your average of all 3 is, to arrive
at
a final grade point average?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Formula for determing average based on weighting

"John Sullivan" wrote:
If you have an 84 average that counts as 60% of a grade
(school); and you have 91 average that counts as 30% of
a grade' and you have 85 average that counts as 10% of
your grade, what is the formula to determine what your
average of all 3 is, to arrive at a final grade point average?


If I interpret your facts correctly, the simplest formula might
be:

=84*60% + 91*30% + 85*10%
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula based on Len forever Excel Discussion (Misc queries) 1 November 3rd 05 01:44 PM
caluculate an average based on 2 criteria [email protected] Excel Discussion (Misc queries) 3 November 3rd 05 04:34 AM
Average Formula with Criteria PW11111 Excel Discussion (Misc queries) 1 June 10th 05 02:22 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
GradeBook WannaKooky Excel Worksheet Functions 1 November 4th 04 03:23 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"