How to Use the IRR Function in WPS on Windows

Use IRR in 4 task-based topics, all available in WPS Spreadsheets on Windows; choose a topic from the How-to Index, then enter the formula, check parameters, and review the result.

How-to Index

How-to Guide

1. Enter the IRR function

Entry point: Formulas tab → formula bar

1. Open WPS Spreadsheets and select the cell where you want the result to appear.
2. Type = in the formula bar or directly in the cell.
3. Continue by typing IRR(.
4. Get ready to enter the cash flow argument range.

Success Criteria

• Interface result: The cell enters formula input mode.
• What you can do next: You can continue entering parameters and complete the formula.

Tips While Using

• Common mistake: If you forget to type = first, the content may be treated as plain text.

2. Fill in parameters with syntax prompts

Entry point: the function prompt area after typing =IRR(

1. After typing IRR(, review the syntax prompt that appears.
2. Enter the correct range or parameter values as prompted.
3. Check that parentheses, separators, and parameter order are correct.
4. Press Enter to confirm the formula.

Success Criteria

• Interface result: The cell returns a calculated result instead of an error.
• What you can do next: You can select the cell again to review or edit the formula.

Tips While Using

• Common mistake: Unmatched parentheses or missing separators can cause formula errors.

3. Calculate with cross-sheet references

Entry point: formula bar

1. In the result cell, type =IRR(.
2. Switch to another worksheet that contains the cash flow data.
3. Select the cell range you want to use as the argument.
4. Press Enter to confirm and return the result.

Success Criteria

• Interface result: The formula includes a cross-sheet reference.
• What you can do next: You can adjust the referenced range or copy the formula to other cells.

Tips While Using

• Common mistake: Including unintended cells in the referenced range can affect the result.

4. Review automatic recalculation after data changes

Entry point: a worksheet that already contains an IRR formula

1. Locate the cash flow range referenced by the IRR formula.
2. Change one or more cash flow values.
3. Watch the result cell for value changes.
4. If needed, review the referenced range and parameter content again.

Success Criteria

• Interface result: The result cell updates when the referenced data changes.
• What you can do next: You can continue adjusting data and compare different outcomes.

Tips While Using

• Common mistake: Numbers stored as text may affect the calculation result.