请问电子表格如何把小写金额在另一行显示大写金额答:B2处输入以下公式 =SUBSTITUTE(SUBSTITUTE(IF(A2<0,"负","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A2,"0.00"))),"角","")&IF(LEFT(RIGHT...
请问电子表格如何把小写金额在另一行显示大写金额答:你把这个复制进去 =TEXT(INT(G14),"[DBNum2]G/通用格式元")&IF(RIGHT(G14*100,2)<>"00",(TEXT(LEFT(RIGHT(G14*100,2),1),"[DBNum2]G/通用格式角")&IF(RIGHT(RIGHT(G14*100,2),1)="0","整",TEXT(RIGHT(RIGHT(G14*100,2),1),"[DBNum2]G/通用格式分"))),"整")把G...