将数字自动转化为文字的公式下载_Word模板_1

is_477730

暂无简介

将数字自动转化为文字的公式=IF(A1=0,"",IF(ABS(A1)<0.995,"",TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2] ")&"元")&IF(RIGHT(TEXT(A1,".00"),2)*1=0,IF(ABS(A1)<0.005,"","零角零分"),TEXT(IF(ABS(A1)<0.095,"",LEFT(RIGHT(TEXT(A1,".00"),2))),"[dbnum2]")& IF(LEFT(RIGHT(TEXT(A1,".00"),2))*1=0,"","角 ")&IF(RIGHT(TEXT...

=IF(A1=0,"",IF(ABS(A1)<0.995,"",TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2] ")&"元")&IF(RIGHT(TEXT(A1,".00"),2)*1=0,IF(ABS(A1)<0.005,"","零角零分"),TEXT(IF(ABS(A1)<0.095,"",LEFT(RIGHT(TEXT(A1,".00"),2))),"[dbnum2]")& IF(LEFT(RIGHT(TEXT(A1,".00"),2))*1=0,"","角 ")&IF(RIGHT(TEXT(A1,".00"))*1=0,"零分 ",TEXT(RIGHT(TEXT(A1,".00")),"[dbnum2]")&"分")))&"整"

本文档为【将数字自动转化为文字的公式】，请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑，图片更改请在作品中右键图片并更换，文字修改请直接点击文字进行修改，也可以新增和删除文档中的内容。

将数字自动转化为文字的公式

热门搜索

历史搜索