EXCEL同一个单元格同时显示金额的大写和小写用什么公式?如壹万伍仟...答:=IF(A1<0,""金额为负无效"",IF((A1=0),""零元整"",IF(A1<1,""",TEXT(INT(A1),""[dbnum2]G/通用格式""&""元"")&IF(INT(A1*10)-INT(A644)*10=0,""","""))&IF(AND((INT(A1*100)-INT(A1*10)*10)<>0,(INT(A1*10)-INT(A1)*10)=0),""零"",IF((INT(A1*...