本帖最后由 深秋的黎明 于 2020-7-5 22:02 编辑
=IF(G13=0,"",(IF(TRUNC(G13)=0,"",TEXT(TRUNC(G13),"[DBNum2]G/通用格式")&"元"))&(IF(AND(TRUNC(G13)<>0,TRUNC(G13*10)-TRUNC(G13)*10=0,TRUNC(G13*100)-TRUNC(G13*10)*10<>0),"零",IF(AND(TRUNC(G13)<>0,TRUNC(G13*10)-TRUNC(G13)*10=0,TRUNC(G13*100)-TRUNC(G13*10)*10=0),"整",IF(TRUNC(G13*10)-TRUNC(G13*10,-1)=0,"",TEXT(TRUNC(G13*10)-TRUNC(G13*10,-1),"[DBNum2]G/通用格式")&"角")))))&(IF(TRUNC(G13*100)-TRUNC(G13*10)*10=0,"",TEXT(TRUNC(G13*100)-TRUNC(G13*10)*10,"[DBNum2]G/通用格式")&"分"))
数据源是单元格G13,你可以通过查找替换的方法随意更改
|