Rentes Rente Formel Excel
| Function | Purpose | | :--- | :--- | | | Find the compound interest rate from start and end values. | | FV | Find the future value given a fixed rate. | | PV | Find the present value given a fixed rate. | | RATE | More flexible version of RRI (handles periodic payments). |
Where:
Here's a review of the compound interest formula in Excel: rentes rente formel excel
=RRI(4, 200000, 120000)
Rate = (End Value / Start Value)^(1/Periods) - 1 | Function | Purpose | | :--- |
The RRI function in Excel is the quickest way to apply the . Instead of typing =(Fv/Pv)^(1/Nper)-1 , simply use: simply use: A very specific topic!
A very specific topic!