|
发表于 2022-12-12 14:42:47
|
显示全部楼层
最后我把公式改成这样,角之后分之前不会多一个零了。=IF(B2=0,"零元",IF(B2<0,TEXT(INT(ABS(B2)),"负[DBNum2][$-804]General")&"元"&IF((INT(B2*10)-INT(B2)*10)=0,"",TEXT(INT(B2*10)-INT(B2)*10,"[DBNum2][$-804]General")&"角")&IF((INT(B2*100)-INT(B2*10)*10)=0,"整",TEXT(INT(B2*10)-INT(B2*10),"[DBNum2][$-804]General")&TEXT(INT(B2*100)-INT(B2*10)*10,"[DBNum2][$-804]General")&"分"),TEXT(INT(B2),"[DBNum2][$-804]General")&"元"&IF(INT(B2*10)-INT(B2)*10=0,"",TEXT(INT(B2*10)-INT(B2)*10,"[DBNum2][$-804]General")&"角")&IF((INT(B2*100)-INT(B2*10)*10)=0,"整",IF(INT(B2*10)-INT(B2)*10=0,"零"&TEXT(INT(B2*100)-INT(B2*10)*10,"[DBNum2][$-804]General")&"分",TEXT(INT(B2*100)-INT(B2*10)*10,"[DBNum2][$-804]General")&"分")))) |
|