excel公式的解释!=IF(ISERROR(FIND(".",B16)),NUMBERSTRING(INT(B16),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(B16,FIND(".",B16)+2,1),2)),NUMBERSTRING(INT(B16),2)&"元"&NUMBERSTRING(MID(B16,FIND(".",B16)+1,1),2)&"角整",NUMBERSTRING(INT(B16),2)&"元"
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/16 02:25:34
![excel公式的解释!=IF(ISERROR(FIND(](/uploads/image/z/4615608-48-8.jpg?t=excel%E5%85%AC%E5%BC%8F%E7%9A%84%E8%A7%A3%E9%87%8A%21%3DIF%28ISERROR%28FIND%28%22.%22%2CB16%29%29%2CNUMBERSTRING%28INT%28B16%29%2C2%29%26%22%E5%85%83%E6%95%B4%22%2CIF%28ISERROR%28NUMBERSTRING%28MID%28B16%2CFIND%28%22.%22%2CB16%29%2B2%2C1%29%2C2%29%29%2CNUMBERSTRING%28INT%28B16%29%2C2%29%26%22%E5%85%83%22%26NUMBERSTRING%28MID%28B16%2CFIND%28%22.%22%2CB16%29%2B1%2C1%29%2C2%29%26%22%E8%A7%92%E6%95%B4%22%2CNUMBERSTRING%28INT%28B16%29%2C2%29%26%22%E5%85%83%22)
excel公式的解释!=IF(ISERROR(FIND(".",B16)),NUMBERSTRING(INT(B16),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(B16,FIND(".",B16)+2,1),2)),NUMBERSTRING(INT(B16),2)&"元"&NUMBERSTRING(MID(B16,FIND(".",B16)+1,1),2)&"角整",NUMBERSTRING(INT(B16),2)&"元"
excel公式的解释!
=IF(ISERROR(FIND(".",B16)),NUMBERSTRING(INT(B16),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(B16,FIND(".",B16)+2,1),2)),NUMBERSTRING(INT(B16),2)&"元"&NUMBERSTRING(MID(B16,FIND(".",B16)+1,1),2)&"角整",NUMBERSTRING(INT(B16),2)&"元"&NUMBERSTRING(MID(B16,FIND(".",B16)+1,1),2)&"角"&NUMBERSTRING(MID(B16,FIND(".",B16)+2,1),2)&"分"))
呵呵,哪位哥们可以详细的解释下以上语句的意思啊!
excel公式的解释!=IF(ISERROR(FIND(".",B16)),NUMBERSTRING(INT(B16),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(B16,FIND(".",B16)+2,1),2)),NUMBERSTRING(INT(B16),2)&"元"&NUMBERSTRING(MID(B16,FIND(".",B16)+1,1),2)&"角整",NUMBERSTRING(INT(B16),2)&"元"
这是个把数字转化为大写金额的公式,但太复杂了,给你简短点的
=IF(OR(B16="",B16=0),"",TEXT(INT(B16),"[dbnum2]")&IF(INT(B16)=B16,"元整","元")&IF(INT(B16)B16,TEXT(--RIGHT(INT(B16*10)),"[=0]零;[>0][dbnum2]#角"),"")&TEXT(--RIGHT(INT(B16*100)),"[dbnum2]#分;;"))