How to Use the MINVERSE Function in WPS on Windows

Last updated:July 20, 2026

Use MINVERSE through 4 task topics, with 4 free topics and 0 membership-related topics; choose a task from the index to complete matrix entry and calculation step by step.

How-to Index

No.TopicMembership Requirement
11. Enter the MINVERSE functionFree
22. Fill in arguments with syntax promptsFree
33. Reference a matrix range from another worksheetFree
44. Review recalculated resultsFree

How-to Guide

1. Enter the MINVERSE function

Entry point: Formula bar or target cell

  1. Open WPS Spreadsheets and go to the workbook where you want to calculate a matrix inverse.
  2. Select the cell where you want the result to appear, or the top-left cell of the output area.
  3. Type = and then type MINVERSE.
  4. Type the opening parenthesis to prepare for the matrix argument.

Success Criteria

  • Interface result: =MINVERSE( appears in the cell or formula bar.
  • You can continue: You can enter a matrix range or switch to another worksheet to select data.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: Matrix data should be stored in a worksheet range that can be referenced.

2. Fill in arguments with syntax prompts

Entry point: Syntax prompt while entering the function

  1. After =MINVERSE( appears, review the function prompt on screen.
  2. Select or type the matrix range you want to calculate.
  3. Confirm that the referenced range has the same number of rows and columns.
  4. Type the closing parenthesis and press Enter to confirm the formula.

Success Criteria

  • Interface result: The full formula appears in the cell or formula bar.
  • You can continue: You can review the result or adjust the referenced range and calculate again.

Tips While Using

  • Common mistake: If the referenced range is not a square matrix, the result may not return as expected.
  • Environment note: The argument range should contain data that can be used in the calculation.

3. Reference a matrix range from another worksheet

Entry point: Formula bar and worksheet tabs

  1. In the target cell, type =MINVERSE(.
  2. Keep the formula active and switch to the worksheet that stores the matrix data.
  3. Select the matrix range so its address is inserted into the formula automatically.
  4. Return to the formula entry point, add the closing parenthesis, and confirm the formula.

Success Criteria

  • Interface result: The formula includes a reference to another worksheet.
  • You can continue: After editing the source worksheet data, you can review how the result changes.

Tips While Using

  • Common mistake: If you switch worksheets but do not confirm the full range, the reference may be incomplete.
  • Environment note: The referenced worksheet should remain in the current workbook.

4. Review recalculated results

Entry point: Result cell with an existing MINVERSE formula

  1. Make sure the MINVERSE formula has already been entered and the result is visible.
  2. Go back to the referenced matrix range and change one or more values.
  3. Review whether the result area updates after the source data changes.
  4. Repeat the adjustment if you want to compare different matrix results.

Success Criteria

  • Interface result: The result updates when the referenced data changes.
  • You can continue: You can keep editing data, copy the formula, or save the workbook.

Tips While Using

  • Common mistake: If you edit a range that is not referenced by the formula, the result will not change.
  • Environment note: Keep the formula references intact and avoid deleting the source matrix range by mistake.