在excel中如何计算工资零钱

Question

如工资为5488.6，应发RMB“54张100，1张50，1张20，1张10，一张5，一张2，一张1,一张5角,一张1角”相关的代码和实现方法吗？ 谢谢

Answer 1

A2为工资额,
B2求百元张数 =int(B2/100)
C2求50元张数 =--int((int(A2)-B2*100)>=50)
D2求20元张数 =int((int(A2)-B2*100-C2*50)/20)
E2求10元张数 =int((int(A2)-B2*100-C2*50-D2*20)/10)
F2求5元张数 =--((int(A2)-int(A2/10)*10)>=5)
G2求2元张数 =int((int(A2)-int(A2/10)*10-F2*5)/2)
H2求1元张数 =int(A2)-int(A2/10)*10-F2*5-G2*2
I2求5角张数 =--((int(A2*10)-int(A2)*10)>=5)
J2求2角张数 =int((int(A2*10)-int(A2)*10-I2*5)/2)
K2求1角张数 =int(A2*10)-int(A2)*10-I2*5-J2*2

Answer 2

在A8输入工资
在A9输入下面公式.

=INT(A8/100)&"张100,"&INT(MOD(A8,100)/50)&"张50,"&INT(MOD(MOD(A8,100),50)/20)&"张20,"&INT(MOD(MOD(MOD(A8,100),50),20)/10)&"张10,"&INT(MOD(MOD(MOD(MOD(A8,100),50),20),10)/5)&"张5,"&INT(MOD(MOD(MOD(MOD(MOD(A8,100),50),20),10),5)/2)&"张2,"&INT(MOD(MOD(MOD(MOD(MOD(MOD(A8,100),50),20),10),5),2)/1)&"张1,"&INT(MOD(MOD(MOD(MOD(MOD(MOD(MOD(A8,100),50),20),10),5),2),1)/0.5)&"张5角,"&INT(MOD(MOD(MOD(MOD(MOD(MOD(MOD(MOD(A8,100),50),20),10),5),2),1),0.5)/0.1)&"张1角"

Answer 3

A2为工资额,
B2求百元张数 =int(B2/100)
C2求50元张数 =--int((int(A2)-B2*100)>=50)
D2求20元张数 =int((int(A2)-B2*100-C2*50)/20)
E2求10元张数 =int((int(A2)-B2*100-C2*50-D2*20)/10)
F2求5元张数 =--((int(A2)-int(A2/10)*10)>=5)
G2求2元张数 =int((int(A2)-int(A2/10)*10-F2*5)/2)
H2求1元张数 =int(A2)-int(A2/10)*10-F2*5-G2*2
I2求5角张数 =--((int(A2*10)-int(A2)*10)>=5)
J2求2角张数 =int((int(A2*10)-int(A2)*10-I2*5)/2)
K2求1角张数 =int(A2*10)-int(A2)*10-I2*5-J2*2