EXCEL单元格格式--数字--特殊,选项里没有 人民币大写的内容呢?_百度知 ...答:选项里面确实没有,但是不等于EXCEL就没有这个功能,自己写IF语句就可以实现,公式如下:=IF(ROUND(A5,2)<0,"无效数值",IF(ROUND(A5,2)=0,"零",IF(ROUND(A5,2)<1,"",TEXT(INT(ROUND(A5,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A5,2)*10)-INT(ROUND(A5,2))*10=0,IF(INT(...
Excel 想在格中显示人民币大写圆整,公式是什么?答:这是前面没有美元符号的公式看你的能不能去掉美元符号=SUBSTITUTE(SUBSTITUTE(IF(C8<0,"负","")&TEXT(TRUNC(ABS(ROUND(C8,2))),"[DBNum2]")&"元 "&IF(ISERR(FIND(".",ROUND(C8,2))),"",TEXT(RIGHT(TRUNC(ROUND(C8,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0"...