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

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/05 18:34:57
函数ROUND(-PMT(5.94%/12,108,H7,0,0),
x){ھ A~.!z&F:::::6IE*/!\gmm~`P复:O;ڀ͙|mEs_lG+Ptvgr0hTTi<tOvMyںTϧ|cɓO7`_\gHC|

函数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四舍五入,保留两位小数