How to Use the MIRR Function in WPS on Windows

This how-to guide includes 3 operation topics, all available without membership; use the How-to Index below to jump to the steps you need.

How-to Index

How-to Guide

1. Enter MIRR from the Insert Function dialog

Entry point: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for MIRR in the dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog.
6. Click OK to finish inserting the formula.

Success Criteria

• The selected cell now contains the MIRR function.
• After the dialog closes, the calculation result appears in the cell.
• You can continue editing parameters or copy the formula to other cells.

Tips While Using

• The parameter order should be values, finance_rate, reinvest_rate.
• The cash flow range should include both positive and negative values.
• The cash flow order should match the actual sequence of events.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =MIRR(...) directly in the cell or formula bar.
3. Press Enter to confirm.
4. If needed, review the syntax prompt after typing =MIRR(.

Success Criteria

• The formula has been entered in the cell.
• After you press Enter, the result appears or the formula remains available for editing.
• The full MIRR formula is visible in the formula bar.

Tips While Using

• Separate parameters with English commas.
• If the result looks incorrect, check whether the referenced range contains text or error values.
• When copying the formula in bulk, review relative and absolute references.

3. Review the syntax and parameter meanings

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Search for MIRR.
3. Select the function and review the syntax: MIRR(values, finance_rate, reinvest_rate).
4. Check the meanings of the cash flow range, financing rate, and reinvestment rate before calculation.

Success Criteria

• You can see the full MIRR syntax structure.
• You can distinguish the meanings of all three parameters.
• You can continue with formula entry or error checking based on that information.

Tips While Using

• values is usually a range of periodic cash flow data.
• finance_rate and reinvest_rate should be entered as rate values.
• If a parameter meaning is unclear, verify the data range before calculating.