How to Use the MIRR Function in WPS on Windows

This how-to guide covers 4 topics for using MIRR in WPS Spreadsheet on Windows, and all 4 are available without membership.

How-to Index

How-to Guide

1. Enter the MIRR function

Entry point: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to begin the formula.
3. Type MIRR(.
4. Review the syntax prompt to confirm the function name and argument order.

Success Criteria

• Interface result: =MIRR( appears in the cell or formula bar.
• Next action available: You can continue entering the arguments.

Tips While Using

• Common mistake: If you do not type = first, the content may be treated as plain text.
• Environment note: The target cell must be editable.

2. Fill in the function arguments

Entry point: Formula bar

1. After MIRR(, enter the cash flow range or array first.
2. Type a comma and enter the finance rate.
3. Type another comma and enter the reinvestment rate.
4. Type ) and press Enter.

Success Criteria

• Interface result: The target cell returns a calculated result.
• Next action available: You can select the result cell to review the full formula.

Tips While Using

• Common mistake: Missing arguments, unmatched parentheses, or incorrect separators can cause an error.
• Environment note: Cash flow data should be arranged in calculation order.

3. Use cross-sheet references

Entry point: Formula bar + sheet tabs

1. Start editing the MIRR formula.
2. Switch to the worksheet that contains the cash flow data.
3. Select the cell range you want to reference so the cross-sheet reference is inserted.
4. Return to the result cell, complete the remaining arguments, and confirm the formula.

Success Criteria

• Interface result: The formula includes a worksheet name and cell range reference.
• Next action available: You can change the referenced data and observe the updated result.

Tips While Using

• Common mistake: If the referenced range includes unexpected text values, the result may not match expectations.
• Environment note: The related worksheets need to remain in the current workbook.

4. Check results and automatic recalculation

Entry point: Result cell + source data range

1. Note the current MIRR result.
2. Change any cash flow value, finance rate, or reinvestment rate.
3. Check whether the result cell updates accordingly.
4. If you need to review the setup, select the formula cell again and inspect the references and arguments.

Success Criteria

• Interface result: The result updates when referenced data changes.
• Next action available: You can continue adjusting inputs for scenario comparison.

Tips While Using

• Common mistake: Numbers stored as text can affect the calculation result.
• Environment note: If workbook calculation settings have been changed, update behavior may differ.