当B1输入数值,相应在A3自动生成大写金额、人民币符号的小写金额,要求在...答:A3公式(只适用于只有正数的情况):="金额(大写):"&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(B1)),"[>0][dbnum2];[<0]负[dbnum2];;")&TEXT(RIGHT(FIXED(B1),2),"元[dbnum2]0角0分;;"&IF(ABS(B1)>1%,"元整",)),"零角",IF(ABS(B1)<1,,"零")),"零分","整") &" ...