请高手帮忙修复公式?
给你个公式,自己加上,就不给你举例了
=IF(ROUND(A1,2)=0,"",IF(ROUND(ABS(A1),2)>=1,TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2]")&"元","")&IF(RIGHT(TEXT(A1,"。 00"),2)*1=0,"整",IF(RIGHT(TEXT(A1,"。00"),4)*1>=1,IF(RIGHT(TEXT(A1,"。00"),2)*1>9,"","零"),IF(ROUND(ABS(A1),2)>=1,"零",""))&IF(RIGHT(TEXT(A1,"。 00"),2)*1>9,TEXT(LEFT(RIGHT...全部
给你个公式,自己加上,就不给你举例了
=IF(ROUND(A1,2)=0,"",IF(ROUND(ABS(A1),2)>=1,TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2]")&"元","")&IF(RIGHT(TEXT(A1,"。
00"),2)*1=0,"整",IF(RIGHT(TEXT(A1,"。00"),4)*1>=1,IF(RIGHT(TEXT(A1,"。00"),2)*1>9,"","零"),IF(ROUND(ABS(A1),2)>=1,"零",""))&IF(RIGHT(TEXT(A1,"。
00"),2)*1>9,TEXT(LEFT(RIGHT(TEXT(A1,"。00"),2)),"[DBNum2]")&"角","")&IF(RIGHT(TEXT(A1,"。00"))*1>0,TEXT(RIGHT(TEXT(A1,"。
00")),"[DBNum2]")&"分","整")))。收起