|
本帖最后由 薄荷语冰 于 2014-3-1 23:08 编辑
=IF(ABS(L11)<0.005,"",IF(L11<0,"负",)&IF(INT(ABS(L11)),TEXT(INT(ABS(L11)),"[dbnum2]")&"元",)&IF(INT(ABS(L11)*10)-INT(ABS(L11))*10,TEXT(INT(ABS(L11)*10)-INT(ABS(L11))*10,"[dbnum2]")&"角",IF(INT(ABS(L11))=ABS(L11),,IF(ABS(L11)<0.1,,"零")))&IF(ROUND(ABS(L11)*100-INT(ABS(L11)*10)*10,),TEXT(ROUND(ABS(L11)*100-INT(ABS(L11)*10)*10,),"[dbnum2]")&"分","整")) 谁能帮我解释下这是什么意思吗?看不懂头都大了,不会用金额转大写的函数。
本帖最后由 baksy 于 2014-3-2 05:27 编辑
=IF(ABS(L11)<0.005,"",IF(L11<0,"负",)&IF(INT(ABS(L11)),TEXT(INT(ABS(L11)),"[dbnum2]")&"元",)
---- 金额小于0.005不计,小于0时为负数,整数部分有值时转成大写"元"
&IF(INT(ABS(L11)*10)-INT(ABS(L11))*10,TEXT(INT(ABS(L11)*10)-INT(ABS(L11))*10,"[dbnum2]")&"角",IF(INT(ABS(L11))=ABS(L11),,IF(ABS(L11)<0.1,,"零")))&
---- 小数点以下第一位大于0时转成大写"角",小数位没有值时不计,否则为"零"
IF(ROUND(ABS(L11)*100-INT(ABS(L11)*10)*10,),TEXT(ROUND(ABS(L11)*100-INT(ABS(L11)*10)*10,),"[dbnum2]")&"分","整"))
---- 小数点第二位有值,转成大写"分",否则为"整"
|
|