本帖最后由 vanxis 于 2020-9-15 10:42 编辑
如下图,左侧是web端表格,右侧是本地表格,金额用公式转大写 的情况下,多出一个0是怎么回事?
公式:
=""&IF(TRIM(F52)="","",IF(F52=0,"",""&IF(F52<0,"负",)&IF(INT(F52),TEXT(INT(ABS(F52)),"[dbnum2]")&"圆",)&IF(INT(ABS(F52)*10)-INT(ABS(F52))*10,TEXT(INT(ABS(F52)*10)-INT(ABS(F52))*10,"[dbnum2]")&"角",IF(INT(ABS(F52))=ABS(F52),,IF(ABS(F52)<0.1,,"零")))&IF(ROUND(ABS(F52)*100-INT(ABS(F52)*10)*10,),TEXT(ROUND(ABS(F52)*100-INT(ABS(F52)*10)*10,),"[dbnum2]")&"分","整")))
|