MINVERSE Function in ONLYOFFICE Spreadsheet Editor: Inverse Matrix Array Formula

=MINVERSE(array)

No argument is optional, and there is no implied default. Source matrix entries should be numeric, including zero where intended; leaving a cell blank is not equivalent to zero in vendor-documented error handling. Preserve the order of arguments when combining matrix functions.

Vendor-confirmed: the source documents #N/A for blanks or nonnumeric cells in the argument and #VALUE! when rows and columns do not match. It does not explicitly prescribe the exact error code for a square but singular matrix, so do not claim a particular native result for =MINVERSE(A11:B12). Mathematically that input has no inverse because its determinant equals 0.

Start with a blank worksheet. Type each entry as a numeric cell (not as quoted text), then place results only in the indicated unused output cells. The sample is deliberately small enough for manual checking.

Select a blank output area before entering each formula. Never overwrite these input ranges with array-formula results. Use one clean worksheet per guide, or reset your worksheet to this exact baseline before moving between scenarios.

How to enter a matrix result correctly

For multi-cell results, first highlight an appropriately sized blank output rectangle; then enter the formula in the formula bar and use Ctrl+Shift+Enter as explained in the ONLYOFFICE array-formula instructions. The editor adds array braces in the formula bar automatically. If you only press Enter, the vendor’s array guide warns that some functions return the first value rather than filling the requested result range. Always select the exact output shape and compare all cells, not just the upper-left cell. The array guide also says you cannot change only part of an entered array: select the entire array to delete or re-enter it.

Each displayed matrix is written as rows inside [[...],[...]]. For example [[2,-1],[-3,2]] means output row one 2, -1 and output row two -3, 2; it is not a formula literal to paste into the spreadsheet. Fill the indicated output rectangle using the actual formula, not by typing the expected array. These predictions were calculated with exact rational SymPy mathematics and do not represent measurements from ONLYOFFICE.

Singular-matrix boundary: =MINVERSE(A11:B12) is a deliberately negative test case. Since A11:B12 has determinant zero, an inverse does not exist mathematically. The official MINVERSE page does not identify its exact native error response for this input. Keep this as a documented test plan, not an expected spreadsheet error string.

A linear system A×x=b can be solved algebraically as x=A⁻¹b. With A in A2:B3 and b in J2:J3, the mathematically expected solution is x₁=2, x₂=1, because 2·2+1·1=5 and 3·2+2·1=8. After separately verifying =MINVERSE(A2:B3), try the array formula =MMULT(MINVERSE(A2:B3),J2:J3) in a two-row output range as an advanced editor check. This nested-array formula and output entry mode have not been run natively. The inverse method is less numerically robust than specialized linear-system solvers for ill-conditioned or large matrices; keep inputs well scaled and verify residuals (A×x−b).

• MDETERM — related matrix operation, with its own documented signature and error conditions.
• MMULT — related matrix operation, with its own documented signature and error conditions.
• MUNIT — related matrix operation, with its own documented signature and error conditions.
• Function entry and argument-picker instructions.
• Array formula entry and array editing.
• Formula language and regional settings.

This guide is based on the current, unversioned English ONLYOFFICE help pages on 2026-10-13 (UTC) and independent numerical reasoning. The sample values below are expected values, not results observed in a running ONLYOFFICE Spreadsheet Editor. No screenshot, workbook execution, web edition test, Desktop edition test, or historic version support test was performed. Use the official function catalogue.

Edition and compatibility: ONLYOFFICE’s documentation describes the current Docs Spreadsheet Editor; its Desktop changelog and Docs changelog are distinct records. None of the cited function pages establishes a first-supported Desktop or web version for this function; do not infer universal historical compatibility or claim that an XLSX exported to another spreadsheet program evaluates identically. Where a function returns an array, the current ONLYOFFICE array-entry guide explicitly describes selecting the complete output range, entering the formula and pressing Ctrl+Shift+Enter. Do not manually type the surrounding { }. In some editions, dynamic-array behaviour may differ and must be tested.

Formula language and separators: The examples use English names, A1-style references, a decimal point, and commas between arguments. The official function-entry guide shows these conventions. The Advanced Settings guide documents configurable formula language, region and numeric separators; it does not provide a verified translation or formula argument separator for every locale. Change regional settings as appropriate and verify the resulting formula entry in the target edition rather than blindly substituting commas with semicolons.