Any way to calculate exponents? Want to manually run PMT() calculation | Community
Skip to main content
Answered

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


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!

Best answer by john.desborough

@hello-test - you are correct. 

 

des

View original

2 replies

john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5312 replies
  • Answer
  • December 8, 2022

@hello-test - you are correct. 

 

des


  • Author
  • Explorer
  • 1 reply
  • December 8, 2022
john.desborough wrote:

@hello-test - you are correct. 

 

des

 

Got it! Thank you!


Reply