记录一下

网页哀悼的样式

<style type="text/css">
*{filter: Gray;}
</style>

excelapi增加人民币转大写公式,不能采用&符号进行字符串连接,必须使用函数CONCATENATE

IF(ROUND(I13,2)<0,\"无效数值\",IF(ROUND(I13,2)=0,\"零\",CONCATENATE(IF(ROUND(I13,2)<1,\"\",CONCATENATE(TEXT(INT(ROUND(I13,2)),\"[dbnum2]\"),\"元\")),IF(INT(ROUND(I13,2)*10)-INT(ROUND(I13,2))*10=0,IF(INT(ROUND(I13,2))*(INT(ROUND(I13,2)*100)-INT(ROUND(I13,2)*10)*10)=0,\"\",\"零\"),CONCATENATE(TEXT(INT(ROUND(I13,2)*10)-INT(ROUND(I13,2))*10,\"[dbnum2]\"),\"角\")),IF((INT(ROUND(I13,2)*100)-INT(ROUND(I13,2)*10)*10)=0,\"整\",CONCATENATE(TEXT((INT(ROUND(I13,2)*100)-INT(ROUND(I13,2)*10)*10),\"[dbnum2]\"),\"分\")))))
阅读更多
换一批

没有更多推荐了,返回首页