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

john.desborough
Forum|alt.badge.img+6

@hello-test - you are correct. 

 

des


john.desborough wrote:

@hello-test - you are correct. 

 

des

 

Got it! Thank you!


Reply