To the power of?

  • Resolved robhorsfall

    (@robhorsfall)


    5 years, 8 months ago

    Hi there,

    Great plugin by the way! Thank you so much!

    I am finding it difficult to trying to get the pow function to work.

    The original code in excel is =SUM(1/((1+0.05)^B2)*B3) with ^ standing for pow

    When I try and replicate this on your plugin, it does not return anything. I am using the code:

    prec((1/((1+0.05)pow*fieldname2)*fieldname11),2)

    Any reason why it might not be working?

    Many thanks

    The page I need help with: [log in to see the link]

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

    (@codepeople)

    5 years, 8 months ago

    Hello @robhorsfall,

    Actually, the POW operation is not being used as should:

    
a^b = POW(a,b)

    So, the equation would be:

    
PREC(1/POW(1+0.05,fieldname2)*fieldname11,2)

    Best regards.

    Thread Starter robhorsfall

    (@robhorsfall)

    5 years, 8 months ago

    Thanks so much for this, that seems to work. But following your same logic, I tried to alter the other sets of forumula:

    =SUM(1/(0.06)+(0.06/((1+0.06)^B2-1)))*B4

    becomes

    PREC((1/(fieldname18+(fieldname18/POW((1+fieldname18,fieldname2-1)))* fieldname12,2)

    and

    =SUM((B8+B9+((B3*(((-0.0001*B2^2)+(0.0194*B2)+0.0108)))))*-1+B3)/2

    becomes

    PREC(((fieldname16+fieldname15+((fieldname11*POW(((-0.0001*fieldname2,2)+(0.0194*fieldname2)+0.0108)))))*-1+fieldname11)/2),2)

    Is that correct? I tried this but both of them did not work…or is the forumula too complex?

    Thanks again.

    Plugin Author codepeople

    (@codepeople)

    5 years, 8 months ago

    Hello @robhorsfall,

    Pay attention to the parentheses, the open and closes parentheses do not match, the correct equation is:

    
PREC((1/fieldname18+(fieldname18/(POW(1+fieldname18,fieldname2)-1)))*fieldname12,2)

    Please, check your second equation.

    If you need additional help implementing all your project’s equations, you should request a custom coding service from my private website:

    https://cff.dwbooster.com/customization

    Best regards.

    Thread Starter robhorsfall

    (@robhorsfall)

    5 years, 8 months ago

    Ok, many thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘To the power of?’ is closed to new replies.