Answered

Any way to calculate exponents? Want to manually run PMT() calculation

  • 8 December 2022
  • 2 replies
  • 22 views

Hi -- I couldn’t find any way to do this, but has anyone had success doing more complex calculations?

 

I tried connecting to Google Sheets or Excel, but seems like Typeform can only send data to those -- not pull data back from a calculated field in Sheets or Excel.

 

I am trying to create a form that estimates payments based on an interest rate, term, principal, which would require implementing this formula:

A = P ( r ( 1 + r ) ^ n ) / ( ( 1 + r ) ^ n - 1 )

 

I’m guessing it’s not possible since it requires the use of exponents?

 

THX!

icon

Best answer by john.desborough 8 December 2022, 18:09

View original

2 replies

Userlevel 7
Badge +6

@hello-test - you are correct. 

 

des

@hello-test - you are correct. 

 

des

 

Got it! Thank you!

Reply