開心生活站

位置:首頁 > 綜合知識 > 

大寫負數怎麼寫

1. 怎麼寫負數大寫

A1輸入數字,在A2或其它單元格輸入公式:=IF(A1="","",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<0,"負","")&IF(ROUND(ABS(A1),2)<1,"",TEXT(INT(ROUND(ABS(A1),2)),"[dbnum2]")&"圓")&IF(INT(ROUND(ABS(A1),2)*10)-INT(ROUND(ABS(A1),2))*10=0,IF(INT(ROUND(ABS(A1),2)*100)-INT(ROUND(ABS(A1),2)*10)*10=0,"","零"),TEXT(INT(ROUND(ABS(A1),2)*10)-INT(ROUND(ABS(A1),2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(ABS(A1),2)*100)-INT(ROUND(ABS(A1),2)*10)*10)=0,"整",TEXT((INT(ROUND(ABS(A1),2)*100)-INT(ROUND(ABS(A1),2)*10)*10),"[dbnum2]")&"分")))

大寫負數怎麼寫

例:人民幣大寫:-71587.96 成爲:負柒萬壹仟伍佰捌拾柒圓玖角陸分

標籤:負數 大寫