Calculate button

Hi,

The URL you sent me, displays a 404 Error, page not found.

Best regards.

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.

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.

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.

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.

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.

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.

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.