EXCEL大写金额公式前面怎么添加符号？

Question

EXCEL大写金额公式前面怎么添加“⊗”“￥”或“大写”，原公式IF(C1=0,"",IF(AND(ISERR(FIND("拾万零",TEXT(INT(C1),"[dbnum2]"))),ISERR(FIND("拾万元",TEXT(INT(C1),"[dbnum2]")&"元"))),SUBSTITUTE(TEXT(INT(C1),"[DBNum2]"),"拾万","拾万零")&"元",TEXT(INT(C1),"[dbnum2]")&"元"))&IF(INT(C1*10)-INT(C1)*10=0,IF(INT(C1)*(INT(C1*100)-INT(C1*10)*10)=0,"","零"),IF(AND((INT(C1)-INT(C1/10)*10)=0,INT(C1)>0),"零"&TEXT(INT(C1*10)-INT(C1)*10,"[dbnum2]")&"角",TEXT(INT(C1*10)-INT(C1)*10,"[dbnum2]")&"角"))&IF((INT(C1*100)-INT(C1*10)*10)=0,"整",TEXT(INT(C1*100)-INT(C1*10)*10,"[dbnum2]")&"分")，金额前面没有显示符号，如果要添加符号公式怎么写，谢谢

Answer 1

在第二个IF前面加，如下：
=IF(C1=0,"","⊗"&IF(AND(ISERR(FIND("拾万零",TEXT(INT(C1),"[dbnum2]"))),ISERR(FIND("拾万元",TEXT(INT(C1),"[dbnum2]")&"元"))),SUBSTITUTE(TEXT(INT(C1),"[DBNum2]"),"拾万","拾万零")&"元",TEXT(INT(C1),"[dbnum2]")&"元"))&IF(INT(C1*10)-INT(C1)*10=0,IF(INT(C1)*(INT(C1*100)-INT(C1*10)*10)=0,"","零"),IF(AND((INT(C1)-INT(C1/10)*10)=0,INT(C1)>0),"零"&TEXT(INT(C1*10)-INT(C1)*10,"[dbnum2]")&"角",TEXT(INT(C1*10)-INT(C1)*10,"[dbnum2]")&"角"))&IF((INT(C1*100)-INT(C1*10)*10)=0,"整",TEXT(INT(C1*100)-INT(C1*10)*10,"[dbnum2]")&"分")

Answer 2

你的公式里已经有连字符&，照猫画虎，在前面接着用：
="￥"&你的原公式