Reply To: PMT Function

[web_editor]

What if the value of pv is the difference of amount-downpayment, while the ir is already define in my real equation

Here

function(){
var interest = 0;
if(5000<=fieldname1 && fieldname1<=12000)
{
if(fieldname22 == 9) interest=0.994;
else if(fieldname22 == 12) interest=0.9351;
else interest=0;
}
if(12001<=fieldname1 && fieldname1<=30000) 
{
if(fieldname22 == 9) interest=0.9383;
else if(fieldname22 == 12) interest=0.917;
else if(fieldname22 == 15) interest=0.8607;
else interest=0;
}
if(30001<=fieldname1 && fieldname1<=60000) 
{
if(fieldname22 == 9) interest=0.9383;
else if(fieldname22 == 12) interest=0.8988;
else if(fieldname22 == 15) interest=0.8429;
else if(fieldname22 == 15) interest=0.7901;
else interest=0;
}

return CEIL((fieldname1-fieldname2/(1-(1/(1+interest/12)*EXP(fieldname22)))/interest/12)/12);
}