支持任意数量、金额
=LET(f,LAMBDA(x,LET(j,SEQUENCE(x+1)-1,k,TRANSPOSE(j),j&"-"&IF(j+k>x,坤,k&"-"&x-j-k))),p,TOCOL(TOROW(f(D2))&"-"&TOCOL(f(D3)),2),IFERROR(--TEXTSPLIT(TEXTJOIN(";",,FILTER(p,MAP(p,LAMBDA(y,SUM({10,5,1,1,0.5,0.1}*TEXTSPLIT(y,"-"))))=D4)),"-",";"),"无解"))
![](http://tiebapic.baidu.com/forum/w%3D580/sign=a62f9ff2bdedab6474724dc8c736af81/cf13ab18972bd40737da32c43d899e510fb309a5.jpg?tbpicau=2024-07-19-05_8f7028c8c8ba522b0813c97882dd1816)