急!!!excel中如何将数字转换为相应人民币面值的张数答:b1: =INT(round(a1,2)/100)c1: =INT(MOD(round(a1,2),100)/50)d1: =INT(MOD(MOD(round(a1,2),100),50)/20)e1: =INT(MOD(MOD(MOD(round(a1,2),100),50),20)/10)f1: =INT(MOD(MOD(MOD(MOD(round(a1,2),100),50),20),10)/5)g1: =INT(MOD(MOD(MOD(MOD(MOD(...