MIRR in WPS on Windows FAQ

This FAQ focuses on 3 common issue types when using MIRR in WPS Spreadsheet: formula errors, unexpected results, and reuse across multiple cells.

FAQ

What should I do if MIRR returns an error value?

1. Check whether the range in the values argument contains numeric data.
2. Make sure the cash flow series includes at least one positive value and one negative value.
3. Confirm that the parameters are separated with English commas.
4. If the referenced cells contain text or extra spaces, clean the data and calculate again.

Why does the MIRR result look different from what I expected?

1. Check whether the cash flows are arranged in the actual order in which they occur.
2. Confirm that finance_rate and reinvest_rate use the intended rate values.
3. Check whether the referenced range is missing cells or includes extra cells.
4. If needed, reopen the Insert Function dialog and review each parameter one by one.

How can I use MIRR in multiple cells at once?

1. Enter the correct MIRR formula in the first target cell.
2. Select that cell and drag the fill handle to copy it to other cells.
3. If some references must stay fixed, use $ for absolute references.
4. After copying, spot-check several results to confirm the references are correct.

Glossary