ABS
这公式太强了，直接贴出来给大家参考一下：=SUBSTITUTE(SUBSTITUTE(IF(A20,负,)&TEXT(TRUNC(
ABS(ROUND(A2,2))), )&元&IF(ISERR(FIND(.,ROUND(A2,2))), , TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)), ))&IF(ISERR(FIND(.0,TEXT(A2,0.00))),角,)&IF(LEFT(RIGHT(ROUND(A2,2),3))=. ,TEXT(RIGHT(ROUND(A2,2)),)&分,IF(ROUND(A2,2)=0,,整)),零元零,),零元,零)这个是如果A2是负数的话，前面会加个负字。如果你想改成负数显示无效数值，那就用这个版本：=IF(ROUND(A2,2)0,无效数值,IF(ROUND(A2,2)=0,零,IF(ROUND(A2,2)1,,TEXT(INT(ROUND(A2,2)),)&元)&IF(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10=0,IF(INT(ROUND(A2,2))*(INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,,零),TEXT(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10,)&角)&IF((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,整,TEXT((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10),)&分))说实话这两个公式都不是我自己写的，是网上大佬的作品，我只是搬运工 有需要的拿去用吧，感谢原作者！
