Skip to main content
karele27896867
Participant
May 9, 2019
Question

Convert Excel formula to Javascript

  • May 9, 2019
  • 1 reply
  • 387 views

Hello,

I would like convert this formulas to work in Javascript.

=(D6*(12/1+(E4-1)*(12/1+1)/2)*(1+(E4^(D10*1)-E4)/(E4-1))+D4*(E4^(D10*1)))*1


D6 = 200000

D10 =1000

E4 = 1,07

result in excel = 1099444,405

please help

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
May 9, 2019

This is just a simple mathematical formula. You just need to get the values of the fields corresponding to the cells from the Excel file, and then perform the calculation and apply it to event.value at the end.

The only difference is in how you would do the exponent function. In JavaScript you do it like this:

Math.pow(a,b)

which is the same as

a^b

The rest is exactly the same.

Also, see this tutorial: https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations