MINVERSE in WPS on Windows FAQ

When using MINVERSE, common questions usually involve formula entry, square matrix ranges, cross-worksheet references, and result updates; the answers below can help you troubleshoot quickly.

FAQ

What should I do if MINVERSE does not return a result?

1. Make sure the formula starts with =.
2. Check that the function name is entered as MINVERSE.
3. Confirm that the parentheses are complete and that you pressed Enter.
4. If the result still does not appear, select the target cell again and re-enter the formula.

Why does the MINVERSE argument need to be a square matrix?

1. Check whether the selected range has the same number of rows and columns.
2. If the current range is not square, reorganize the data into a square matrix.
3. Edit the formula again so the argument points to the correct square range.

How do I reference data from another worksheet in MINVERSE?

1. Type =MINVERSE( in the result cell first.
2. Switch to the worksheet that contains the matrix data and select the target range.
3. Return and complete the closing parenthesis, then confirm the formula.
4. Save the workbook if you want to keep using the cross-worksheet reference later.

Why did the result not update after I changed the source data?

1. Confirm that you changed the matrix range actually referenced by the formula.
2. Check that the formula is still a formula and was not changed into plain text.
3. Select the result cell and confirm that the referenced address is still correct.
4. If needed, re-enter the formula to restore the reference relationship.

Glossary