如图:
AW5公式:
=IF(OR($K$1>AW$4,$AK5=SUM($AV5:AV5)),"",IF($AK5-SUM($AV5:AV5)>$AQ5,$AP5,$AK5-SUM($AV5:AV5)))
右拉;
AW6公式:
=IF(OR($K$1>AW$4,$AK6=SUM($AV6:AV6),SUM(IFERROR(AW$5:AW5/$AP$5:$AP5,0))>=1),"",IF($AK6-SUM($AV6:AV6)>(1-SUM(IFERROR(AW$5:AW5/$AP$5:$AP5,0)))*$AP6,(1-SUM(IFERROR(AW$5:AW5/$AP$5:$AP5,0)))*$AP6,$AK6-SUM($AV6:AV6)))
数组公式,按组合键(CTRL+SHIFT+回车)完成公式,右拉,下拉。