=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"[dbnum2]")&IF(INT(F9)=F9,"元整","元")&IF(INT(F9)<>F9,IF(RIGHT(INT(F910))=0,"零",TEXT(RIGHT(INT(F910)),"[dbnum2]#角"))&I

来源：学生作业帮助网编辑：作业帮时间：2024/11/15 03:47:02

=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函数部分,但是也没看出问题来啊