Formulas > =RATE()
How To Use RATE() Function in Google Sheets
Description
How To Actually Use RATE() in Sheets
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
Try RATE yourself
In cells A1:A5, enter the number of periods, payment per period, present value, future value, and whether payments are at the beginning or end. Use the RATE function in cell B1 to calculate the interest rate based on these values.
Hints (3)
-
Make sure to enter the correct values in A1 to A5.
-
Remember that future value and payment timing are optional.
-
Check the syntax of the RATE function.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the RATE() formula:
Generate a RATE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses RATE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a RATE() formula