本帖最后由 砂海 于 2017-3-15 20:57 编辑
X19
=IF(OR(Q19="",U19=""),"",U19*Q19)
D22
=LOOKUP(1,0/({"※","0","1","2","3","4","5","6","7","8","9"}=MID(REPT("※",8-LEN(INT($V$22*100)))&INT($V$22*100),(COLUMN()-2)/2,1)),{"※","零","壹","贰","叁","肆","伍","陆","柒","捌","玖"})
D22 这样短些
=INDEX({"※","零","壹","贰","叁","肆","伍","陆","柒","捌","玖"},FIND(MID(REPT("※",8-LEN(INT($V$22*100)))&INT($V$22*100),(COLUMN()-2)/2,1),{"※0123456789"}))
另: sum() 提前处理一下 , 确保为2位小数 , D22公式不要int() , 更好些
D22
=MID({"※零壹贰叁肆伍陆柒捌玖"},FIND(MID(REPT("※",8-LEN(INT($V$22*100)))&INT($V$22*100),(COLUMN()-2)/2,1),{"※0123456789"}),1)
|