Returns the equivalent interest rate for the growth of an investment.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
RRI(nper, pv, fv)The RRI function calculates the interest rate required for an investment to grow from a beginning value to a future value over a specified number of periods. It is useful for determining the annual or periodic yield needed to reach a specific financial goal.
=RRI(5, 1000, 1500)結果: 0.08447
Calculates the interest rate required for 1,000 to grow to 1,500 over 5 periods.
The function will return the #NUM! error if nper <= 0 or if pv and fv are not greater than zero.