Use the RRI function through 4 operation topics, including entering the function, checking syntax guidance, building cross-sheet references, and creating nested calculations.

How-to Index

No.	Topic	Membership Requirement
1	1. Enter the RRI function	Free
2	2. Check syntax guidance	Free
3	3. Use cross-sheet references	Free
4	4. Build a nested calculation	Free

How-to Guide

1. Enter the RRI function

Entry point: Formulas tab → formula bar

Open WPS Spreadsheet and select the cell where you want the result to appear.
Type = in the selected cell or in the formula bar.
Type RRI(.
Enter the number of periods, present value, and future value in order.
Type the closing parenthesis and press Enter.

Success Criteria

Interface result: The target cell displays a calculated result.
Next action: You can copy the formula, change parameters, or format the cell.

Tips While Using

Common mistake: If you forget = or leave parentheses unmatched, the formula may not calculate correctly.
Environment note: Make sure the referenced values match the intended calculation.

2. Check syntax guidance

Entry point: formula bar

Select an empty cell.
Type =RRI(.
Watch for the syntax guidance shown in the editing area.
Complete the parameters based on the prompt.

Success Criteria

Interface result: Parameter guidance appears after the function name is entered.
Next action: You can continue entering the formula with the displayed guidance.

Tips While Using

Common mistake: If the function name is misspelled, the expected guidance may not appear.

3. Use cross-sheet references

Entry point: formula bar

In the result cell, type =RRI(.
Switch to the worksheet that contains the source values.
Select the cells for the number of periods, present value, and future value in order.
Complete the closing parenthesis and press Enter.

Success Criteria

Interface result: The formula includes references to another worksheet.
Next action: When source values change, the result updates accordingly.

Tips While Using

Common mistake: If the reference order is wrong, the result may be incorrect.
Environment note: The referenced worksheet needs to remain accessible.

4. Build a nested calculation

Entry point: formula bar

Select the cell where you want to display the result.
Enter a combined formula that includes RRI.
Use other functions as arguments or wrap the RRI result in an outer function.
Check parentheses and separators, then press Enter.

Success Criteria

Interface result: The cell returns the result of the combined formula.
Next action: You can continue adjusting the outer function or internal references.

Tips While Using

Common mistake: In deeper nested formulas, parentheses and argument positions are easier to misplace.