How to Use the MIRR Function in WPS on Windows

Last updated:July 20, 2026

This section covers 4 how-to topics for MIRR, including entering the function, filling in arguments from syntax guidance, using cross-sheet references or nested formulas, and checking recalculated results.

How-to Index

No.TopicMembership Requirement
11. Enter the MIRR functionFree
22. Fill in arguments from syntax guidanceFree
33. Use cross-sheet references or nested formulasFree
44. Check recalculated resultsFree

How-to Guide

1. Enter the MIRR function

Entry point: Formula tab → formula bar

  1. Open WPS Spreadsheet and go to the workbook where you want to calculate a result.
  2. Select the cell that should display the result.
  3. Type = in the formula bar or directly in the cell.
  4. Type MIRR( to begin entering the function.

Success Criteria

  • Interface result: The selected cell enters formula editing mode.
  • Next action available: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: You need an editable spreadsheet cell.

2. Fill in arguments from syntax guidance

Entry point: Select the target cell → type =MIRR(

  1. After typing MIRR(, review the syntax guidance that appears.
  2. Enter the cash flow range, finance rate, and reinvestment rate in the required order.
  3. Check separators and parentheses before confirming the formula.
  4. Press Enter to calculate the result.

Success Criteria

  • Interface result: The cell shows a calculated value instead of raw formula text.
  • Next action available: You can select the cell again to review or edit the formula.

Tips While Using

  • Common mistake: Mismatched parentheses, missing arguments, or incorrect separators can cause formula errors.

3. Use cross-sheet references or nested formulas

Entry point: Formula bar

  1. Select the result cell and start editing the MIRR formula.
  2. When you need source data, switch to another worksheet and select the required cell or range.
  3. If you need a more advanced model, add other formulas or referenced results inside the MIRR arguments.
  4. Confirm the formula structure and press Enter to finish the calculation.

Success Criteria

  • Interface result: The formula bar shows cross-sheet references or a nested formula structure.
  • Next action available: You can change referenced data and observe the updated result.

Tips While Using

  • Common mistake: An incomplete referenced range can affect the final result.
  • Environment note: The related worksheets and referenced cells need to remain accessible.

4. Check recalculated results

Entry point: Edit data referenced by MIRR

  1. Find the cash flow or rate cells referenced by the MIRR formula.
  2. Change one or more values in those cells.
  3. Return to the result cell and check whether the value updates.
  4. If the result does not update as expected, review the reference range and data format.

Success Criteria

  • Interface result: The result cell updates when referenced data changes.
  • Next action available: You can continue adjusting inputs and compare outcomes.

Tips While Using

  • Common mistake: Numbers stored as text or incorrect references can cause unexpected results.
  • Environment note: In workbooks with complex dependencies, review the reference chain step by step.