75% equals 40 points and 40 points is 100% of the points

[mobieestus]

If a 75% is actually worth 100% to my customer, then what formula would I use to figure out the how many points I get out of 40 if I get 72%?
Points avaialble=40
Percentage to get 40 points=75%
What formula can be used to figure out the amount of points received for different percentages?

 

[shg]

=40/75 * 72

 

[mobieestus]

Thank you shg for the quick response. That worked perfectly. My next question is if there is a way for it to stop calculating ar 40 points. Since the max is 40 points I want to hit 40 at 75% and then stop increasing the points.

 

[shg]

=40*min(1, 72/75)

 

[mobieestus]

This formula lets the points go over 40 when the percentage is over 75%.

 

[Scott Huish]

How can 75% = 100%?

If 75% = 40 points then 100% = 53 1/3

So you have to work from the whole amount:

Excel Workbook
	A	B	C	D
1			Percent	Result
2	53.33333		72%	38.4
3			60%	32
4			76%	40
5			100%	40
Sheet1

 

[mobieestus]

Thanks HOTPEPPER. This worked perfectly, but I changed it a little bit. To avoid putting 53.33333 in a random cell I just added it to the formula in place of the $A$2.

 

[Scott Huish]

You're welcome.

If those amounts stay constant, then:

=MIN(40,C2*(53+1/3))