Interest Calculation with exponents

  • Resolved kronos1337

    (@kronos1337)


    5 years, 10 months ago

    Hi, I have following formular, that I want to calculate:
    p: Interest e.g. 3% (fieldname11) which has to be typed in as number 3
    n: Investment period e.g. 5 years (fieldname10)

    Here the calculation:
    (1,03^5-1)/(1,03-1)

    I thought this would be the calculation, but something is wrong:
    ((POW(1+fieldname11/100),fieldname10)-1)/((1+fieldname11/100)-1)

    Could you please help me, thank you

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @kronos1337

    The use of the parentheses in your equation is wrong. The correct equation would be:

    
(POW(1+fieldname11/100,fieldname10)-1)/((1+fieldname11/100)-1)

    Please, compare it with your equation.
    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Interest Calculation with exponents’ is closed to new replies.

Tags