Equation with pow

  • Resolved depor15

    (@depor15)


    5 years, 11 months ago

    Hi,

    I need help to implementing equation :
    In excel : (C6*12*(1-(1+(C5/100)/12)^(-C4)))/(C5/100)

    I can not transcribe the formula on the plugin

    Can anyone help me ?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    5 years, 11 months ago

    Hello @depor15,

    The equation is very simple. I’ll assume, to describe the equation, that the fields are:

    C4 is the fieldname4
    C5 is the fieldname5
    and C6 is the fieldname6

    Note that in our plugin the fields’ names are generated dynamically, so, you should use the corresponding fields’ names in your form.

    With these fields the equation would be:

    
fieldname6*12*(1-POW(1+(fieldame5/100)/12, -1*fieldname4))/(fieldname5/100)

    Best regards.

    Thread Starter depor15

    (@depor15)

    5 years, 10 months ago

    Thank you very much

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Equation with pow’ is closed to new replies.