Skip to main content
Answered

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

  • December 8, 2022
  • 2 replies
  • 29 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!

Best answer by john.desborough

@hello-test - you are correct. 

 

des

2 replies

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

@hello-test - you are correct. 

 

des


  • Author
  • Explorer
  • December 8, 2022

@hello-test - you are correct. 

 

des

 

Got it! Thank you!