Functions
RATE
Interest rate per period
Try it
When to use it
When should I use RATE instead of NPER?
Use RATE to solve for the periodic interest rate; use NPER to solve for the number of periods.
Use cases
Annualize a monthly loan rate
Solve the implied rate on an investment goal
Used in
finance · lending · personal-finance
Syntax
RATE(nper, pmt, pv)Examples
=RATE(12,-100,400,0,0,0.1) // => 0.228933070977093