工作需要总会涉及到金额大小写,想问用EXCEL函数怎样可以大小写自动换算...答:假设你的金额录入在B1 则 IF(TRIM(B1)="","",IF(B1=0,"",""&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(B1)),"[dbnum2]G/通用格式元;负[dbnum2]G/通用格式元;"&IF(B1>-0.5%,,"负"))&TEXT(RIGHT(FIXED(B1),2),"[dbnum2]0角0分;;"&IF(ABS(B1)>1%,"整",)),"零角",IF(...