=IF(I25="","",IF(I25<0,"负",)&IF(INT(I25),TEXT(INT(ABS(I25)),"[dbnum2]")&"元",)&IF(INT(ABS(I25)*10)-INT(ABS(I25))*10,TEXT(INT(ABS(I25)*10)-INT(ABS(I25))*10,"[dbnum2]")&"角",IF(INT(ABS(I25))=ABS(I25),,IF(ABS(I25)<0.1,,"零")))&IF(ROUND(ABS(I25)*100-INT(ABS(I25)*10)*10,),TEXT(ROUND(ABS(I25)*100-INT(ABS(I25)*10)*10,),"[dbnum2]")&"分","整")) 上面是一个奖人民币金额小写转大写的公式.我在I25单元格中输入金额的小写,但按要求我不用精确到"分".只要到"角"就可以了.请问应该怎样修改公式?
1个方法,改公式,如下: =IF(I26="","",IF(I26<0,"负",)&TEXT(INT(I26),"[dbnum2]")&"元"&IF(INT(ABS(I26)*10)-INT(ABS(I26))*10,TEXT(INT(ABS(I26)*10)-INT(ABS(I26))*10,"[dbnum2]")&"角","")&IF(ROUND(ABS(I26)*100-INT(ABS(I26)*10)*10,),"","整")) 另一个方法,不改公式,让你的I25单元格,用round函数处理,使它不出现分 弱弱的说一句,原公式当I25,输入“0”时,只显示个“整”字,MS这个不符合大写的规矩吧
|