excel中有没有能把小写数字金额转换成大写汉字金额的公式？

问题补充说明：excel中有没有能把小写数字金额转换成大写汉字金额的公式？详细点的，本人工作需要！谢谢！

=IF(OR(A1<0,A1=""),"",IF(VALUE(LEFT(A1,1))=0,"",NUMBERSTRING(INT(A1),2)&"元")&IF(ISERROR(FIND(".",A1)),"整",IF(VALUE(MID(A1,FIND("."元电,A1)+1,1))=0,"零",IF(ISERROR(FIND(".",A1)),"",NUMBERSTRING(MID(A1,FIND(".",A1)+1,1),2)&"角")))&IF(ISERROR(FIND(".",A1)),"",IF(LEN(ROUND(A1,2))=(FIND(".",A1)+2),NUMBERSTRING(MID(ROUND(A1,2),FIND(".",A1)+2360问答,1),2)&"分","")))&IF(ISERROR(FIND(".",A1)),"","")----丝是---------------------------------------------------------------------------------------------------------------早-------------------------老呢过地管久指万述----------------------------------------------------------------------------公式引用了A1单元格的部升虽实限讲组理数字，在B1单元格转成大写金额。NUMBERSTRING函数可将数字转成大写。