if(e110,"金额为负无效",if(and((int(e11*10)-int(e11)*10)=0,(int(e11*100)-int(e11*10)*10)=0),text(int(e11),"[dbnum2]")&"元整",if((int(e11*100)-int(e11*10)*10)=0,text(int(e11),"[dbnum2]")&"元"&text(int(e11*10)-int(e11)*10,"[dbnum2]")&"角整",text(int(e11),"[dbnum2]")&"元"&text(int(e11*10)-int(e11)*10,"[dbnum2]")&"角"&text(if((int(e11*1000)-int(e11*100)*10)=5,(int(e11*100)-int(e11*10)*10)+1,int(e11*100)-int(e11*10)*10),"[dbnum2]")&"分整")))这是标准的!大写的不能用那个写法
Copyright © 2025 IZhiDa.com All Rights Reserved.
知答 版权所有 粤ICP备2023042255号