excl表格大写金额公式

使用公式拆分处理（支持角、分）
‌适用场景‌：金额包含小数（精确到分），且需要动态更新。
=Sheet3!A1&IF(G10<0,"负","")&IF(TRUNC(G10)=G10,TEXT(IF(G10<0,-G10,G10),"[DBNum2]")&"元整",IF(TRUNC(G10*10)=G10*10,TEXT(TRUNC(IF(G10<0,-G10,G10)),"[DBNum2]")&"元"&TEXT(RIGHT(G10),"[DBNum2]")&"角整",TEXT(TRUNC(G10),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".0",G10)),"零",TEXT(LEFT(RIGHT(G10,2)),"[DBNum2]")&"角")&TEXT(RIGHT(G10),"[DBNum2]")&"分"))