表格中输入数字怎么变成大写金额元正
将需要转换的数字设置为A1,在A2输入以下公式即可:=IF(A1=0,"",IF(ABS(A1)<0。995,"",TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2]")&"元")&IF(RIGHT(TEXT(A1,"。 00"),2)*1=0,IF(ABS(A1)<0。005,"","零角零分"),TEXT(IF(ABS(A1)<0。095,"",LEFT(RIGHT(TEXT(A1,"。00"),2))),"[dbnum2]")&IF(LEFT(RIGHT(TEXT(A1,"。 00"),2))*1=0,"","角")&IF(RIGHT(TEXT(A1,"...全部
将需要转换的数字设置为A1,在A2输入以下公式即可:=IF(A1=0,"",IF(ABS(A1)<0。995,"",TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2]")&"元")&IF(RIGHT(TEXT(A1,"。
00"),2)*1=0,IF(ABS(A1)<0。005,"","零角零分"),TEXT(IF(ABS(A1)<0。095,"",LEFT(RIGHT(TEXT(A1,"。00"),2))),"[dbnum2]")&IF(LEFT(RIGHT(TEXT(A1,"。
00"),2))*1=0,"","角")&IF(RIGHT(TEXT(A1,"。00"))*1=0,"零分",TEXT(RIGHT(TEXT(A1,"。00")),"[dbnum2]")&"分")))&"整"【如果我的回答对你有用,麻烦设为好评,谢谢】。收起