如何将一个单元格中小写金额在另外一个单元格中显示大写金额
2个回答
展开全部
比如D47单元格为小写金额，公兄猜虚式为：
=IF(D47<0,"负","")&TEXT(TRUNC(ABS(ROUND(D47,2))),"羡燃[DBNum2]")&"圆"&IF(ISERR(FIND(".",ROUND(D47,2))),"",TEXT(RIGHT(TRUNC(ROUND(D47,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(D47,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(D47,2),3))="兆态.",TEXT(RIGHT(ROUND(D47,2)),"[DBNum2]")&"分","整")
=IF(D47<0,"负","")&TEXT(TRUNC(ABS(ROUND(D47,2))),"羡燃[DBNum2]")&"圆"&IF(ISERR(FIND(".",ROUND(D47,2))),"",TEXT(RIGHT(TRUNC(ROUND(D47,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(D47,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(D47,2),3))="兆态.",TEXT(RIGHT(ROUND(D47,2)),"[DBNum2]")&"分","整")
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
如A1为小写金额孝高，羡慎厅B1为大写金额则
B1=TEXT(A1*100,"[dbnum2]0拾0万兄隐0仟0佰0拾0元0角0分")
B1=TEXT(A1*100,"[dbnum2]0拾0万兄隐0仟0佰0拾0元0角0分")
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
