公式如下，直接在你相應的單元格複製等號以後的公式。最後兩行是五角和1角的，不用可以不復制。b4是你金額所在的起始位，然後向下拉動公式即可

c4: =INT(round(b4,2)/100)

d4: =INT(MOD(round(b4,2),100)/50)

e4: =INT(MOD(MOD(round(b4,2),100),50)/20)

f4: =INT(MOD(MOD(MOD(round(b4,2),100),50),20)/10)

g4: =INT(MOD(MOD(MOD(MOD(round(b4,2),100),50),20),10)/5)

h4: =INT(MOD(MOD(MOD(MOD(MOD(round(b4,2),100),50),20),10),5)/1)

i4:=INT(MOD(MOD(MOD(MOD(MOD(MOD(ROUND(B2,1),100),50),20),10),5),1)/0.5)

j4:=MOD(MOD(MOD(MOD(MOD(MOD(MOD(ROUND(b4,1)*10,1000),500),200),100),50),10),5)