角和分不能自动识别正确，帮我看下这个公式哪有问题？=IF(F27=0,\"\",IF(INT(F27),TEXT(TRUNC(F27),\"[dbnum2]\")&\"元\",\"\")&IF(MOD(F27,1)=0,\"整\",IF(TRUNC(F27,1),IF(F27=TRUNC(F27,1),TEXT(LEFT(RIGHT(F27*100,2)),\"[dbnum2]0角整\"),TEXT(RIGHT(H34*100,2),\"[dbnum2]0\"&IF(LEFT(RIGHT(H34*100,2))=\"0\",\"\",\"角\")&\"0分\")),TEXT(H34*100,\"[dbnum2]0分\"))))
问题已解决
所属话题：
#Excel#
84784980 | 提问时间：2020 07/15 09:46
你好，**数字小写转大写可以用这个公式：=IF(F27<0,负,)&TEXT(TRUNC(ABS(ROUND(F27,2))),[DBNum2])&元&IF(ISERR(FIND(.,ROUND(F27,2))),,TEXT(RIGHT(TRUNC(ROUND(F27,2)*10)),[DBNum2]))&IF(ISERR(FIND(.0,TEXT(F27,0.00))),角,)&IF(LEFT(RIGHT(ROUND(F27,2),3))=.,TEXT(RIGHT(ROUND(F27,2)),[DBNum2])&分,整)
2020 07/15 16:59
630相关问答
查看更多最新问答
查看更多