EXCEL大写金额公式前面怎么添加符号?
发布网友
发布时间：2022-04-24 14:50
共2个回答
热心网友
时间：2023-01-31 02:18
在第二个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]")&"分")
热心网友
时间：2023-01-31 03:36
你的公式里已经有连字符&，照猫画虎，在前面接着用：
="￥"&你的原公式
