[已解决]支票打印求高手帮忙看下

hfq_007614

做了个支票打印模板，在人民帀大写时有角无分时怎样写函数才能显示“整”啊？例：捌元捌角整

最佳答案

月排行榜 / 总排行榜

zjdh

2011-9-15 08:47

=IF(ROUND(D4,2)<0,"",IF(ROUND(D4,2)=0,"零",IF(ROUND(D4,2)<1,"",TEXT(INT(ROUND(D4,2)),"[dbnum2]")&"元")&IF(INT(ROUND(D4,2)*10)-INT(ROUND(D4,2))*10=0,IF(INT(ROUND(D4,2))*(INT(ROUND(D4,2)*100)-INT(ROUND(D4,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(D4,2)*10)-INT(ROUND(D4,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(D4,2)*100)-INT(ROUND(D4,2)*10)*10)=0,"整",TEXT((INT(ROUND(D4,2)*100)-INT(ROUND(D4,2)*10)*10),"[dbnum2]")&"分")))

跳转到最佳答案楼层

zjdh

=IF(ROUND(D4,2)<0,"",IF(ROUND(D4,2)=0,"零",IF(ROUND(D4,2)<1,"",TEXT(INT(ROUND(D4,2)),"[dbnum2]")&"元")&IF(INT(ROUND(D4,2)*10)-INT(ROUND(D4,2))*10=0,IF(INT(ROUND(D4,2))*(INT(ROUND(D4,2)*100)-INT(ROUND(D4,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(D4,2)*10)-INT(ROUND(D4,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(D4,2)*100)-INT(ROUND(D4,2)*10)*10)=0,"整",TEXT((INT(ROUND(D4,2)*100)-INT(ROUND(D4,2)*10)*10),"[dbnum2]")&"分")))

zjdh

=IF(D4>0.99,IF((D4-INT(D4))=0,NUMBERSTRING(D4,2)&"元整",IF(VALUE(RIGHT(D4*100,2))<10,NUMBERSTRING(INT(D4),2)&"元零"&NUMBERSTRING(RIGHT(D4*100,1),2)&"分",IF(VALUE(RIGHT(D4*100,1))>0,NUMBERSTRING(INT(D4),2)&"元"&NUMBERSTRING(MID(RIGHT(D4*100,2),1,1),2)&"角"&NUMBERSTRING(RIGHT(D4*100,1),2)&"分",NUMBERSTRING(INT(D4),2)&"元"&NUMBERSTRING(MID(RIGHT(D4*100,2),1,1),2)&"角整"))),IF(D4<=0.09,NUMBERSTRING(RIGHT(D4*100,1),2)&"分",IF(OR(D4=0.1,D4=0.2,D4=0.3,D4=0.4,D4=0.5,D4=0.6,D4=0.7,D4=0.8,D4=0.9),NUMBERSTRING(MID(RIGHT(D4*100,2),1,1),2)&"角整",NUMBERSTRING(MID(RIGHT(D4*100,2),1,1),2)&"角"&NUMBERSTRING(RIGHT(D4*100,1),2)&"分")))

9lee

1. =IF(OR(D4<0,D4=""),"",IF(-LEFT(D4,1)=0,"",NUMBERSTRING(INT(D4),2)&"元")&IF(ISERROR(FIND(".",D4)),"整",IF(-MID(D4,FIND(".",D4)+1,1)=0,"零",NUMBERSTRING(MID(D4,FIND(".",D4)+1,1),2)&"角"))&IF(LEN(ROUND(D4,2))=(FIND(".",D4)+2),NUMBERSTRING(MID(ROUND(D4,2),FIND(".",D4)+2,1),2)&"分","整"))

复制代码

hfq_007614

9lee 发表于 2011-9-15 09:02

谢谢，可是所有整数不可显示！显“VALUE”

hfq_007614

回复 zjdh 的帖子

很好，谢谢

9lee

回复 hfq_007614 的帖子

现在好了：

1. =IF(OR(D4<0,D4=""),"",IF(-LEFT(D4,1)=0,"",NUMBERSTRING(INT(D4),2)&"元")&IF(ISERROR(FIND(".",D4)),"整",IF(-MID(D4,FIND(".",D4)+1,1)=0,"零",NUMBERSTRING(MID(D4,FIND(".",D4)+1,1),2)&"角"))&IF(ISERROR(FIND(".",D4)),"",IF(LEN(ROUND(D4,2))=(FIND(".",D4)+2),NUMBERSTRING(MID(ROUND(D4,2),FIND(".",D4)+2,1),2)&"分","整")))

复制代码