Percent Function Help

[Pauline]

Can someone help. I am trying to calculate the percent rank, but here is what
I can't figure out. I have 4 columns of data A, B, C, D column A is worth 25%
and B, C, and D totaled is worth 75% . I need to know what the percent rank
is for this person. There is a total of 25 people.

Thanks

 

[Gary Brown]

What is the criteria for ranking?

 

[Pauline]

I am sorry I don't understand.

What is the criteria for ranking?

 

[Gary Brown]

You said that Col A is 25% and Cols B+C+D = 75% and you want to know the
ranking % of each person.
Do you want to rank them based on their value in Col B? Col C? Col D?
Some combination of columns?
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown

 

[Pauline]

I want to rank them based on col A's value counting 25% and the total value
of B, C, D's Columns counting 75%

Does this make sense?

 

[David Biddulph]

No, it doesn't make sense.
Try giving us an example.

 

[Pauline]

Okay,
Column A Column B Column C Column D
Column E
Test Score Hour Points GPA Points Grade Points
Sum 0f A,B,C

45 10 40 45
95

How do I calculate a total score/grade with Column E worth 75% and Column A
worth 25%? Then once I have this answer rank them so that I will know who has
the highest score/grade

Does this help?

 

[Pauline]

I'm sorry, it wrapped my list.

Column A Column E
Test Score Is sum a of B, C, D
45 95

 

[Spiky]

Okay,
Column A Column B Column C Column D
Column E
Test Score Hour Points GPA Points Grade Points
Sum 0f A,B,C

45 10 40 45
95

How do I calculate a total score/grade with Column E worth 75% and Column A
worth 25%? Then once I have this answer rank them so that I will know who has
the highest score/grade

Does this help?

Is this all you are looking for?
=A2*x+E2*3x

Any "x" will do, perhaps you want to make the total possible points
equal 100 or some round number, so make x be something useful.

Then take the student scores as a percent to get grades, of course.
Presumably in a different cell.

 

[Spiky]

Okay,
Column A Column B Column C Column D
Column E
Test Score Hour Points GPA Points Grade Points
Sum 0f A,B,C

45 10 40 45
95

How do I calculate a total score/grade with Column E worth 75% and Column A
worth 25%? Then once I have this answer rank them so that I will know who has
the highest score/grade

Does this help?

I thought I posted this, maybe two posts will show up eventually.

=A2*x+E2*3x

"x" can be anything, probably best to make it meaningful. For
instance, x=.30303 would give you a total of 100 if the numbers you
gave (45 and 95) are the maximum points available.

Regardless, take the number you've calculated as each student's score
and get grades as a percent of the maximum, of course.

 

[Pauline]

Thank you soooo much! I was trying to make it harder than it actually was.
Argh!

 

[Spiky]

No problem.