如何在Excel下实现金额的大小写转换?
1个回答
展开全部
设小写金额存在在H11单元格，则公式为：
IF(INT(H11),TEXT(INT(H11),"[dbnum2]")&"元",)&IF(INT(H11*10)-INT(H11)*10,TEXT(INT(H11*10)-INT(H11)*10,"[dbnum2]")&"角",IF(INT(H11)=H11,,IF(H11<0.1,,"零")))&IF(ROUND((H11)*100-INT(H11*10)*10,),TEXT(ROUND(H11*100-INT(H11*10)*10,),"[dbnum2]")&"分。","整。"))
IF(INT(H11),TEXT(INT(H11),"[dbnum2]")&"元",)&IF(INT(H11*10)-INT(H11)*10,TEXT(INT(H11*10)-INT(H11)*10,"[dbnum2]")&"角",IF(INT(H11)=H11,,IF(H11<0.1,,"零")))&IF(ROUND((H11)*100-INT(H11*10)*10,),TEXT(ROUND(H11*100-INT(H11*10)*10,),"[dbnum2]")&"分。","整。"))
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
