金額換各種幣值 計算各種幣值張數 (13446)

C2:I6=INT(($B2-SUMPRODUCT(N(+$B$1:B$1)*$B2:B2))/C$1)

C7:I7=SUM(C2:C6)

J2:J6=SUMPRODUCT(C$1:I$1*C2:I2)

C8:I8{=SUM(INT(($B2:$B6-IFERROR(INT($B2:$B6/B1)*B1,))/C1))