=IF(ROUND(A1,2)<0,\"无效数值\零
\元
\")&IF(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10=0,IF(INT(ROUND(A1,2))*(INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,\"\零角
\"),TEXT(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10,\"[dbnum2]\")&\"角\")&IF((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,\"整
\分\")))
Alt+0165
¥
因篇幅问题不能全部显示，请点此查看更多更全内容