Create function in Calculator filed form plugin for excel

enter image description here

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

Leave a Reply

Your email address will not be published. Required fields are marked *