after input formula e.g. =pmt(0.3/12,36,60000)
cell is empty. cell formatting is empty / lost
manually change the cell format to general
correct result shown
Reproducible: Always
Steps to Reproduce:
after input formula e.g. =pmt(0.3/12,36,60000)
Actual Results:
cell is empty. cell formatting is empty / lost
Expected Results:
correct result shown
Additional Information:
have to manually change the cell format to general
Did you get the syntax correct for the formula? =PMT(rate,nper,pv,fv,type)
reference
yes correct. fv and type is optional. =pmt(0.3/12,24,60000,0,0) would suffer same symptom. empty after input. change cell to type general give correct result -3354.76. =pmt(0.3/12,24,60000) would give same 3354.76
system
(system)
Closed
June 29, 2025, 1:05pm
4
This topic was automatically closed 45 days after the last reply. New replies are no longer allowed.