excel formula to distribute value

[excelkaacc]

amount received 125000

amount receivable amount paid
100000
30000
30000
30000
50000
100000


i need a formula that when i put amount in a cell amount received it distributes the value in column of amount paid matching with values in amount receivable like in this example in 1 row of amount paid it should be 100000 and in 2nd row it should be 25000 and others should be 0

 

[Eric W]

Welcome to the Board.

How about:

	A	B
1	Amt received	125000
2
3	Amt receivable paid
4	100000	100000
5	30000	25000
6	30000	0
7	30000	0
8	50000	0
9	100000	0

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Worksheet Formulas Cell Formula B4 =MIN(A4,$B$1-SUM($B$3:$B3)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[excelkaacc]

Thanks alot eric thats all i needed
thanks for your help again

 

[Eric W]

You're welcome.