- Picture and text skills
- Case
Returns the inverse matrix of the array matrix.
Syntax
MINVERSE(array)
Array is a numeric array with an equal number of rows and columns.
Description
• Array can be a cell range, such as B2: D4; array constant such as {1,2,3;4,5,6;7,8, 9}; or the names of range and array constants.
• If the cell in the Array is a non-numeric value type, the function MINVERSE returns the error value #VALUE!.
• If the number of rows and columns of Array Not equal, the function MINVERSE also returns the error value #VALUE!.
• For formulas that return an array, Must be entered as an array formula.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-xue-he-san-jiao-han-shu-MINVERSE-han-shu-qiu-ni-ju-zhen-hang-lie-shi.html
支付宝扫一扫 
评论列表（196条）
测试