Forum Discussion

AlexR's avatar
AlexR
Qrew Trainee
4 years ago

How to write this formula in Quickbase?

Hello,

I hope someone with more experience can help me with this. I want to calculate a monthly payment for the loan using the following formula:

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

A= Monthly Payment, P= Loan Amount, r= Interest Rate, n= Payment Period. The part I am stuck with is (1+r)n
Do you have any ideas about the best way to make this formula work? Thank you.

------------------------------
Aleksandra R.
------------------------------

2 Replies

  • The exponent function is the ^ over the 6 on the keyboard.

     for example 10^2 would equal 100.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • AlexR's avatar
      AlexR
      Qrew Trainee
      Thanks, Mark. That was easier than I thought. :)

      ------------------------------
      Aleksandra R
      ------------------------------