老师怎样设置像图片一样，每个数字对应的大写显示在每一个单元格
问题已解决
所属话题：
#Excel#
84785030 | 提问时间：2020 01/15 20:04
输入函数(复制粘贴即可)
=IF(A1<0,"无效值",IF(A1=0,"零元",IF(A1<1,"",TEXT(INT(A1),"[DBNUM2]")&"元")&IF(INT(A1*10)-INT(A1)*10=0,IF((INT(A1)*(INT(A1*100)-INT(A1*10)*10))=0,"","零"),TEXT(INT(A1*10)-INT(A1)*10,"[DBNUM2]")&"角")&IF(INT(A1*100)-INT(A1*10)*10=0,"整",TEXT(INT(A1*100)-INT(A1*10)*10,"[DBNUM2]")&"分")))
2020 01/15 22:38
897相关问答
查看更多最新问答
查看更多