=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"[dbnum2]")&IF(INT(F9)=F9,"元整","元")&IF(INT(F9)<>F9,IF(RIGHT(INT(F9*10))=0,"零",TEXT(RIGHT(INT(F9*10)),"[dbnum2]#角"))&I
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 18:50:54
![=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"[dbnum2]")&IF(INT(F9)=F9,"元整","元")&IF(INT(F9)<>F9,IF(RIGHT(INT(F9*10))=0,"零",TEXT(RIGHT(INT(F9*10)),"[dbnum2]#角"))&I](/uploads/image/z/4931592-24-2.jpg?t=%3DIF%28OR%28F9%3D%26quot%3B%26quot%3B%2CF9%3D0%29%2C%26quot%3B%26quot%3B%2CTEXT%28INT%28F9%29%2C%26quot%3B%5Bdbnum2%5D%26quot%3B%29%26amp%3BIF%28INT%28F9%29%3DF9%2C%26quot%3B%E5%85%83%E6%95%B4%26quot%3B%2C%26quot%3B%E5%85%83%26quot%3B%29%26amp%3BIF%28INT%28F9%29%26lt%3B%26gt%3BF9%2CIF%28RIGHT%28INT%28F9%2A10%29%29%3D0%2C%26quot%3B%E9%9B%B6%26quot%3B%2CTEXT%28RIGHT%28INT%28F9%2A10%29%29%2C%26quot%3B%5Bdbnum2%5D%23%E8%A7%92%26quot%3B%29%29%26amp%3BI)
=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"[dbnum2]")&IF(INT(F9)=F9,"元整","元")&IF(INT(F9)<>F9,IF(RIGHT(INT(F9*10))=0,"零",TEXT(RIGHT(INT(F9*10)),"[dbnum2]#角"))&I
=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"[dbnum2]")&IF(INT(F9)=F9,"元整","元")&IF(INT(F9)<>F9,IF(RIGHT(INT(F9*10))=0,"零",TEXT(RIGHT(INT(F9*10)),"[dbnum2]#角"))&IF(RIGHT(ROUND(F9,2)*100)=0,"整",TEXT(RIGHT(ROUND(F9,2)*100),"[dbnum2]#分")),""))
公式如上,计算结果除了在分的部分为0有误以外其他都没什么问题,目测结果出现在最后一个if函数部分,但是也没看出问题来啊
=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"[dbnum2]")&IF(INT(F9)=F9,"元整","元")&IF(INT(F9)<>F9,IF(RIGHT(INT(F9*10))=0,"零",TEXT(RIGHT(INT(F9*10)),"[dbnum2]#角"))&I
感觉你的公式在处理角或分其中一个为0时,都会出现问题.