=IF(ROUND(A2,2)=0,"",IF(ROUND(ABS(A2),2)>=1,TEXT(INT(ROUND(ABS(A2),2)),"[DBNum2]")&"元","")&IF(RIGHT(TEXT(A2,".00"),2)*1=0,"整",IF(RIGHT(TEXT(A2,".00"),4)*1>=1,IF(RIGHT(TEXT(A2,".00"),2)*1>9,"","零"),IF(ROUND(ABS(A2),2)>=1,"零",""))&IF(RIGHT(TEXT(A2,".00"),2)*1>9,TEXT(LEFT(RIGHT(TEXT(A2,".00"),2)),"[DBNum2]")&"角","")&IF(RIGHT(TEXT(A2,".00"))*1>0,TEXT(RIGHT(TEXT(A2,".00")),"[DBNum2]")&"分","整")))
拿走不谢
