Excel表格中怎么显示大写圆角分整

发布网友发布时间：2022-04-26 20:45

共1个回答

热心网友时间：2023-10-31 05:38

1.=TEXT(A3*100,"[dbnum2]0佰0拾0万0千0佰0拾0元0角0分")2.=IF(ROUND(A2,2)<0,"无效数值",IF(ROUND(A2,2)=0,"零",IF(ROUND(A2,2)<1,"",TEXT(INT(ROUND(A2,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10=0,IF(INT(ROUND(A2,2))*(INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,"整",TEXT((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10),"[dbnum2]")&"分")))3.="(人民币大写):"&IF(A12<0,"",IF((INT(A12*100)-INT(A12)*100)=0,TEXT(INT(A12),"[DBNUM2]G/通用格式元整"),IF(A12<1,IF((INT(A12*10)-INT(A12)*10)=0,TEXT(INT(A12*100)-INT(A12*10)*10,"[DBNUM2]G/通用格式分"),IF((INT(A12*100)-INT(A12*10)*10)=0,TEXT(INT(A12*10)-INT(A12)*10,"[DBNUM2]G/通用格式角整"),TEXT(INT(A12*10)-INT(A12)*10,"[DBNUM2]G/通用格式角")&TEXT(INT(A12*100)-INT(A12*10)*10,"[DBNUM2]G/通用格式分"))),IF((INT(A12*100)-INT(A12*10)*10)=0,TEXT(INT(A12),"[DBNUM2]G/通用格式元")&TEXT(INT(A12*10)-INT(A12)*10,"[DBNUM2]G/通用格式角整"),IF((INT(A12*10)-INT(A12)*10)=0,TEXT(INT(A12),"[DBNUM2]G/通用格式元")&TEXT(INT(A12*100)-INT(A12*10)*10,"零[DBNUM2]G/通用格式分"),TEXT(INT(A12),"[DBNUM2]G/通用格式元")&TEXT(INT(A12*10)-INT(A12)*10,"[DBNUM2]G/通用格式角")&TEXT(INT(A12*100)-INT(A12*10)*10,"[DBNUM2]G/通用格式分"))))))

热心网友时间：2023-10-31 05:38