excel函数:大写函数如何做?答:假设A1为阿拉伯数字,要在B1显示大写金额 B1=IF(ROUND(A1,2)<0,"金额为负数无效",IF(OR(ROUND(A1,2)=0, ROUND(A1,2)=""),"零元",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元"& IF(INT(ROUND(A1,2)*100)=INT(ROUND(A1,2))*100, "整",IF(INT(ROUND(A1,2)*10)=INT(ROUND(...
小写转大写的函数格式?答:A1=2008,B1=12,C1=21,依次转换公式为:=TEXT(LEFT(A1,1),"[DBNum2][$-804]G/通用格式")&TEXT(MID(A1,2,1),"[DBNum2][$-804]G/通用格式")&TEXT(MID(A1,3,1),"[DBNum2][$-804]G/通用格式")&TEXT(MID(A1,4,1),"[DBNum2][$-804]G/通用格式")=TEXT(B1,"[DBNum2][$...