Prorated based points

[nbkjytr]

Please help on setting up the formula to distribute the points on prorated basis.

Eg:
In the below table in an example for a test result and maximum points allocated for the test is 10, so the person who gets 100% score gets all the 10 points. Need a formula which will give points based on prorated basis based on the test score.

Name	Maximum Points	Test Score	Points
Sarah	10	100%	10
Jane	10	100%	10
Diaz	10	90%	?
Diane	10	80%	?
Angela	10	100%	10

 

[Ezguy4u]

nbkjytr does this answer your problem? If not let us know. Don't forget to format column C using %

Book1
	A	B	C	D
1	Name	Maximum Points	Test Score	Points
2	Sarah	10	100%	10
3	Jane	10	100%	10
4	Diaz	10	90%	9
5	Diane	10	80%	8
6	Angela	10	100%	10
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=D2/B2