Formula for equally share a value based on contribution

[DaVinci07]

I am looking for your support in finding a formula to equally share a value based on an imposed quota fulfillment. For instance, I have to share a quota of 30 units to 4 members. Each of these members have a different quota to cover, A= 10 ( fulfilled 4), B= 5 (fulfilled 8) C= 4 (fulfilled 3), D=40(fulfilled 30) E= 9(fulfilled 6). Each of them has covered to a certain extent their quotas. How to share the equally share the value based on covered

 

[StephenCrump]

Welcome to the Forum!

It's not clear what you mean by "equally share"? It would help if you could provide some examples.

How do you want your 30 units distributed? What if you had 10 units to be distributed instead?

	A	B	C	D	E
1		Quota	Filled	Unfilled	Answer
2	A	10	4	6	?
3	B	5	8	0	?
4	C	4	3	1	?
5	D	40	30	10	?
6	E	9	6	3	?
Sheet1

Cell Formulas
Range	Formula
D2:D6	D2	=MAX(0,B2-C2)