EXCEL公式修复见附件
=IF(B1<0,"金额为负无效",(IF(OR(B1=0,B1=""),"(人民币)零元",IF(B1<1,"人民币",TEXT(INT(B1),"(人民币)[DBNum2][$-804]G/通用格式"&"元"))&IF((INT(B1*100)-INT(B1)*100)=0,"整",TEXT(INT(B1*10)-INT(B1)*10,"[DBNum2][$-804]G/通用格式"&"角")&IF((INT(B1*100)-INT(B1*10)*10)=0,"整",TEXT((INT(B1*100)-INT(B1*10)*10),"[DBNum2][$-804]G/通用格式")&"分"...全部
=IF(B1<0,"金额为负无效",(IF(OR(B1=0,B1=""),"(人民币)零元",IF(B1<1,"人民币",TEXT(INT(B1),"(人民币)[DBNum2][$-804]G/通用格式"&"元"))&IF((INT(B1*100)-INT(B1)*100)=0,"整",TEXT(INT(B1*10)-INT(B1)*10,"[DBNum2][$-804]G/通用格式"&"角")&IF((INT(B1*100)-INT(B1*10)*10)=0,"整",TEXT((INT(B1*100)-INT(B1*10)*10),"[DBNum2][$-804]G/通用格式")&"分")))))
修改为：
=IF(B1<0,"金额为负无效",(IF(OR(B1=0,B1=""),"(人民币)零元",IF(B1<1,"人民币",TEXT(INT(B1),"(人民币)[DBNum2][$-804]G/通用格式"&"元"))&IF((INT(B1*100)-INT(B1)*100)=0,"整",IF(MIDB(ROUND(B1,2),LEN(ROUND(B1,2))-1,1)="0","",TEXT(INT(B1*10)-INT(B1)*10,"[DBNum2][$-804]G/通用格式"&"角"))&IF((INT(B1*100)-INT(B1*10)*10)=0,"整",TEXT((INT(B1*100)-INT(B1*10)*10),"[DBNum2][$-804]G/通用格式")&"分")))))。
收起
