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

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/04 02:42:21
函数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四舍五入,保留两位小数