Hi,
The URL you sent me, displays a 404 Error, page not found.
Best regards.
Thread Starter
UserDG
(@tenkepadu)
ops. sorry, its visible now
Hi,
In your form, the button called “calculate” is of type “button”, and should be of type “calculate”.
Best regards.
Thread Starter
UserDG
(@tenkepadu)
If i change that, it will recalculate the monthly payment if I chage the no. of terms? even if i didn’t click the reset?
Hi,
Yes, each time you press the “Calculate” button, will be evaluated all equations.
Best regards.
Thread Starter
UserDG
(@tenkepadu)
it’s not working.
I choose laptop
amount: 50000
downpayment: 12000
I choose 9 terms
monthly: 4,167
but when i change the no.of terms, the monthly is not changing
Hi,
Your form is working fine, but the interest applied to the months selection provoke very small changes in the results, and you are using the operation CEIL, so, all results will rounded to the higher integer.
For example:
If you select the Mobile/Table in the “Types of Good”, enter 5010 for the “Price of Good”, enter 100 in the “Down Payment”, and finally selects 9 months.
The interest would be 1.6721, and the equation’s result: 417.5000584036477
If you selects 12 months the interes would be 1.5248, and the equation’s result: 417,50000315386757
In both cases the result of the CEIL operation would be: 418.
Best regards.
Thread Starter
UserDG
(@tenkepadu)
I see. What should I use? Should I combine CEIL and PREC?
Hi,
Yes, of course, but what result do you want to get?
Best regards.
Thread Starter
UserDG
(@tenkepadu)
I want to get what the result will produce of my equation with CEIL
CEIL((fieldname1-fieldname2/(1-(1/(1+interest/12)*EXP(fieldname22)))/interest/12)/12);
Hi,
You should set the PREC operation as the last operation in the equation, or the result will be an integer number.
Best regards.
Thread Starter
UserDG
(@tenkepadu)
Like this
CEIL(PREC(fieldname1-fieldname2/(1-(1/(1+interest/12)*EXP(fieldname22)))/interest/12))/12)?
Hi,
If the CEIL is the most external operation you will receive an integer number.
Best regards.
Thread Starter
UserDG
(@tenkepadu)
Hmm. What do you mean the PREC operation must a last operation in equation?
Hi,
Something like this:
PREC(CEIL((fieldname1-fieldname2/(1-(1/(1+interest/12)*EXP(fieldname22)))/interest/12)/12),2);
Best regards.
