函数ROUND(-PMT(5.94%/12,108,H7,0,0),

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/26 04:38:49
函数ROUND(-PMT(5.94%/12,108,H7,0,0),函数ROUND(-PMT(5.94%/12,108,H7,0,0),函数ROUND(-PMT(5.94%/12,108,H7,0,0

函数ROUND(-PMT(5.94%/12,108,H7,0,0),
函数ROUND(-PMT(5.94%/12,108,H7,0,0),

函数ROUND(-PMT(5.94%/12,108,H7,0,0),
-PMT(5.94%/12,108,H7,0,0)的意思是
H7单元格的钱,分108期等额还清,利率是每期5.94%/12.
round(xx,2),将XX四舍五入,保留两位小数