各幣值 準備數 小數點進位 (15109)

C2:K8=INT((ROUNDUP($A2,)-SUMPRODUCT($A$1:B$1,$A2:B2))/C$1)

C10:K10=SUM(C2:C8)

依A欄直接統計 C11:K11{=SUM(IF(C1=$K1,1-ISERR(FIND(RIGHT(ROUNDUP($A2:$A8,)),1368)),INT(MOD(ROUNDUP($A2:$A8,),IF(N(B1),B1,"1E9"))/C1)))