=IF(A3<0,"负","")&IF(A3=0,"",IF(ABS(A3)<0.995,"",IF(AND(RIGHT(INT(ROUND(ABS(A3),2)/10000))="0",RIGHT(INT(ROUND(ABS(A3),2)/1000))<>"0"),SUBSTITUTE(TEXT(INT(ROUND(ABS(A3),2)),"[DBNum2]"),"万","万零"),TEXT(INT(ROUND(ABS(A3),2)),"[DBNum2]"))&"元")&IF(RIGHT(TEXT(A3,".00"),2)*1=0,IF(ABS(A3)<0.005,"","整"),IF(ABS(A3)<0.095,"",IF((LEFT(RIGHT(TEXT(A3,".00"),2))<>"0")*(ABS(A3)>=1),IF(RIGHT(TRUNC(A3),1)>="1","","零"),"")&TEXT(LEFT(RIGHT(TEXT(A3,".00"),2)),"[dbnum2]"))&IF(LEFT(RIGHT(TEXT(A3,".00"),2))*1=0,"","角")&IF(RIGHT(TEXT(A3,".00"))*1=0,"整",TEXT(RIGHT(TEXT(A3,".00")),"[dbnum2]")&"分"))) |