When using the RRI function in WPS, common questions usually involve errors, result checks, and repeated use across cells; this FAQ covers 3 common questions.
FAQ
What should I do if the RRI function shows a #VALUE! error?
- Check whether each parameter is a numeric value and does not contain extra text or spaces.
- Make sure the formula uses English commas as separators.
- If the source data is inconsistent, clean the values and enter the formula again.
What should I do if the RRI result does not match my expectation?
- Check whether the referenced cells and parameter order are correct.
- Confirm that the related cells are formatted as numbers instead of text.
- Review the formula step by step if you need to verify the calculation logic.
How can I use the RRI function in multiple cells?
- Enter the complete RRI formula in the first target cell.
- Drag the fill handle from the lower-right corner of the cell across the target range, or copy and paste the formula into other cells.
- After filling, check whether relative and absolute references behave as expected.
Glossary
| Term | Definition |
|---|---|
| RRI | A financial function that returns the equivalent interest rate for growth from a present value to a future value over a given number of periods. |
| nper | The total number of periods used in the calculation. |
| pv | The present value, or the starting amount. |
| fv | The future value, or the ending amount. |