
I am using Calculator fields plugin in my localhost.My client wants some calculation from excel sheet. iam not getting how to make PV function in calculator plugin form.
(function(){
var principal = fieldname38;
var interest = fieldname45/12/100;
var x = Math.pow(1 + interest, fieldname46*12);
var monthly = (principal*x*interest)/(x-1);
return PREC(monthly,2);
})();
This is not correct calculation can anyone give me solution ?
Read more here:: Create function in Calculator filed form plugin for excel