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
Amt received
Amt receivable paid

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]125000[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"]100000[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]25000[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]100000[/TD]
[TD="align: right"]0[/TD]

</tbody>

Sheet6​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B4[/TH]
[TD="align: left"]=MIN(A4,$B$1-SUM($B$3:$B3))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[excelkaacc]

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

 

[Eric W]

You're welcome.