怎样用excel给工资配钞,计算工资100元、50元、20元、10元、5元、1元...答:简单制作如下表:B1到G1公式如下,按照需求进行修改。B2:=IF(LEN(A2)>=3,LEFT(A2,LEN(A2)-2))C2:=IF(RIGHT(A2,2)>="50","1","0")D2:=IF(RIGHT(A2,2)<="50",INT(RIGHT(A2,2)/20),"0")E2:=INT((RIGHT(A2,2)-20*D2)/10)F2:=INT((RIGHT(A2,2)-20*D2)/10)...