...同时在另一个单元格按标准支票格式显示大写,如何做到?答:=IF(AND(INT(AD1)=0,AD1<>0),"",IF(AND(AD1>10000,INT((AD1/100000-INT(AD1/100000))*10)=0,INT((AD1/10000-INT(AD1/10000))*10)>0),IF(ISERR(FIND("万",TEXT(AD1,"[DBNum2]g/通用格式"))),SUBSTITUTE(TEXT(INT(AD1),"[DBNum2]g/通用格式"),"亿","亿零"),...