Difference in percentages

[Jkeeno122]

I am currently trying to figure out how to get excel to work out the difference of percentage to a while number so I can show staff how many more need to be hit rather than just a percentage.

I.e
Floor average stats 190,125 risks at a retention rate of 76.39%

Agent 1 has 328 risks at a retention rate of 81.71%

I want excel to calculate how many risks over or under the specific agent is

 

[StephenCrump]

Welcome to the Forum!

Like this perhaps?

	A	B	C	D	E
1
2	Floor average	76.39%
3
4	Agent	Risks	Retained	%	Over/Under
5	1	328	268	81.71%	+17
6	2	500	350	70.00%	-32
7
Sheet1

Cell Formulas
Range	Formula
D5:D6	D5	=C5/B5
E5:E6	E5	=INT(C5-B$2*B5)

... but any individual agent changes will of course change the overall average!

 

[Jkeeno122]

Welcome to the Forum!

Like this perhaps?

	A	B	C	D	E
1
2	Floor average	76.39%
3
4	Agent	Risks	Retained	%	Over/Under
5	1	328	268	81.71%	+17
6	2	500	350	70.00%	-32
7
Sheet1

Cell Formulas
Range	Formula
D5:D6	D5	=C5/B5
E5:E6	E5	=INT(C5-B$2*B5)

... but any individual agent changes will of course change the overall average!

That's perfect. Thank you !

 

[StephenCrump]

No problem. I'm glad we could help.