| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Formula
I am trying to calcualte the average of a group of 3 cells that will make up
15% of an overall score. The remaining 3 cells (scores) will make up the remaining percentages in this order, 25%, 30%, and 30%. I'm trying to use AVERAGEA and other AVERAGE formulas but I can't figure it out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average Formula
FWIW, the percentages will be 5%, 5%, 5%, 25%, 30%, 30%. Averaging is
unnecessary racerx66 wrote: I am trying to calcualte the average of a group of 3 cells that will make up 15% of an overall score. The remaining 3 cells (scores) will make up the remaining percentages in this order, 25%, 30%, and 30%. I'm trying to use AVERAGEA and other AVERAGE formulas but I can't figure it out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average Formula
I have three scores of a sample spreasheet that I need the average for and
that average will count towards 15% of an overall score. The remaining 3 scores will compile the remaining 85%, broken down as follows, 25%, 30%, amd 30% If Average is not necessary, what formula can I use to calculate this? "Bob I" wrote: FWIW, the percentages will be 5%, 5%, 5%, 25%, 30%, 30%. Averaging is unnecessary racerx66 wrote: I am trying to calcualte the average of a group of 3 cells that will make up 15% of an overall score. The remaining 3 cells (scores) will make up the remaining percentages in this order, 25%, 30%, and 30%. I'm trying to use AVERAGEA and other AVERAGE formulas but I can't figure it out. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average Formula
That's what I'm trying to tell you. You don't need to "average the 3
scores". The each of the first 3 is 5% of the overall score. Averaging is a wasted step, you don't need to calculate it. So the six scores are the make up the overall scores as stated (5%, 5%, 5%, 25%, 30%, 30%) racerx66 wrote: I have three scores of a sample spreasheet that I need the average for and that average will count towards 15% of an overall score. The remaining 3 scores will compile the remaining 85%, broken down as follows, 25%, 30%, amd 30% If Average is not necessary, what formula can I use to calculate this? "Bob I" wrote: FWIW, the percentages will be 5%, 5%, 5%, 25%, 30%, 30%. Averaging is unnecessary racerx66 wrote: I am trying to calcualte the average of a group of 3 cells that will make up 15% of an overall score. The remaining 3 cells (scores) will make up the remaining percentages in this order, 25%, 30%, and 30%. I'm trying to use AVERAGEA and other AVERAGE formulas but I can't figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula | Excel Discussion (Misc queries) | |||
| formula average | Excel Discussion (Misc queries) | |||
| Formula for Average | Excel Discussion (Misc queries) | |||
| Average formula | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
