|
楼主 |
发表于 2016-7-8 21:44
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 cbtaja 于 2016-7-8 22:03 编辑
- =TEXT(RMB(A2,2),";负;")&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/通用格式元;;")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A2,2),2),"[dbnum2]0角0分;;"),"零分","整"),"零角",IF(A2^2<1,,"零"))
复制代码
再减少2个字符,共158字符,0元整显示为空:(如果习惯让0元显示为“零元整”,则见21楼的165字公式。)
- =IF(A2>-0.5%,,"负")&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/通用格式元;;")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A2,2),2),"[dbnum2]0角0分;;"),"零分","整"),"零角",IF(A2^2<1,,"零"))
复制代码
|
|