MIRR in WPS on Windows FAQ

This FAQ covers 4 common questions about formula entry, argument understanding, unexpected results, and recalculation checks for MIRR in WPS on Windows.

FAQ

What should I do if the MIRR function returns an error?

1. Check whether the formula starts with =.
2. Make sure the parentheses are complete and the separators are correct.
3. Confirm that the cash flow values, finance rate, and reinvestment rate are all included.
4. If needed, re-enter MIRR( and follow the syntax prompt.

How can I view the MIRR function arguments?

1. Select the target cell.
2. Type =MIRR(.
3. Review the syntax prompt that appears during formula entry.
4. Enter the arguments in the displayed order and complete the calculation.

Why is my MIRR result not correct?

1. Check whether the cash flow range includes both negative and positive values.
2. Confirm that the cash flows are arranged in the actual sequence of occurrence.
3. Check for text-formatted numbers or incorrect references in the referenced cells.
4. After editing the data, review whether the result updates.

Why does the result not change after I edit the data?

1. Confirm that the formula still references the correct range.
2. Check whether the edited data is actually part of the MIRR calculation.
3. Select the formula cell again and make sure the arguments were not replaced with fixed values.
4. If necessary, re-enter the formula and test again.

Glossary