+ Reply to Thread
Results 1 to 8 of 8

Problem with inverse matrixes 6x6 matrix

  1. 03-22-2014, 05:41 PM #1
    fabio12
    fabio12 is offline
    Registered User
    Join Date
    03-22-2014
    Location
    myan
    MS-Off Ver
    Excel 2010
    Posts
    4

    Problem with inverse matrixes 6x6 matrix

    Hi,

    I get an error when I try to inverse the 6x6 matrix.
    Should give me a 6x6 matrix again.

    I've attached a screenshot.Screenshot 2014-03-22 22.07.28.png

    I run excel 2010
    Reply With QuoteRegister To Reply
  2. 03-22-2014, 06:15 PM #2
    Max, Singapore
    Max, Singapore is offline
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Problem with inverse matrixes 6x6 matrix

    First, select the results range eg: B34:G39
    Then place the formula in the formula bar: =MINVERSE(B15:G20)
    Press CTRL+SHIFT+ENTER to array-enter the formula
    -------------------------
    Any good? Wave it, whack the the little star at the bottom left of my responses
    Reply With QuoteRegister To Reply
  3. 03-22-2014, 06:20 PM #3
    fabio12
    fabio12 is offline
    Registered User
    Join Date
    03-22-2014
    Location
    myan
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem with inverse matrixes 6x6 matrix

    Hi Max,

    I've done exactly that and I get thisScreenshot 2014-03-22 23.19.16.png
    Last edited by fabio12; 03-22-2014 at 06:23 PM.
    Reply With QuoteRegister To Reply
  4. 03-22-2014, 06:27 PM #4
    Max, Singapore
    Max, Singapore is offline
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Problem with inverse matrixes 6x6 matrix

    Perhaps you might want to check up Excel help on that function?
    This remark seems relevant to your instance:
    Some square matrices cannot be inverted and will return the #NUM! error value with MINVERSE.
    Reply With QuoteRegister To Reply
  5. 03-22-2014, 06:36 PM #5
    fabio12
    fabio12 is offline
    Registered User
    Join Date
    03-22-2014
    Location
    myan
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem with inverse matrixes 6x6 matrix

    well i tryied it just with a part of the 6x6 matrix,
    the upper left 3x3 matrix and it worked.

    i increased the calculating steps in the option after the help function suggested that. nothing changed
    Reply With QuoteRegister To Reply
  6. 03-22-2014, 06:52 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Problem with inverse matrixes 6x6 matrix

    In a single cell, enter =mdeterm(B15:G20)

    What's that return?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  7. 03-22-2014, 07:01 PM #7
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Problem with inverse matrixes 6x6 matrix

    Doh -- never mind. The first two columns are the same, so the matrix is singular (non-invertible).

    So are the third and fourth columns.
    Reply With QuoteRegister To Reply
  8. 03-22-2014, 07:06 PM #8
    fabio12
    fabio12 is offline
    Registered User
    Join Date
    03-22-2014
    Location
    myan
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem with inverse matrixes 6x6 matrix

    Ah thanks shg!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate Matrix Inverse without the MINVERSE function in excel
    By shirleyxiao in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2013, 11:17 AM
  2. Need help with inverse matrix
    By kylwggns in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2012, 11:02 AM
  3. Inverse Matrix Function Problem
    By MichielVrijbergen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2011, 10:21 AM
  4. Inverse Matrix
    By adashiu in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-23-2010, 11:24 AM
  5. How to compute the inverse of a matrix with some complex elements
    By Annoushka42 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-05-2006, 08:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1