+ Reply to Thread
Results 1 to 2 of 2

Matrix Multiplication:Excel SOMETIMES

  1. #1
    Matrix Bill
    Guest

    Matrix Multiplication:Excel SOMETIMES

    I am having a problem with matrix functions in general. No matter what
    variation of sequences I use (the correct one included) I find that Excel
    SOMETIMES only returns a portion of the result, one cell, the a11 location.
    It is clear that Excel is doing the calculation properly as it is displayed
    in the fx window, when the result is an Identity matrix Excel returns a 1 in
    a11 location. I know that I have used the same sequence and procedure and
    received different results.
    I know I must be doing something wrong but cannot figure it out... help
    please.
    Bill

  2. #2
    Conrad Carlberg
    Guest

    re: Matrix Multiplication:Excel SOMETIMES

    Hi Bill,

    You don't mention it, so I'll ask: are you beginning by selecting the full
    range of cells that the result of your matrix operation should return? For
    example, if the operation should return a 4 X 6 matrix, you need to begin by
    selecting a 4 X 6 range of cells, and _then_ array-enter the function.

    --
    C^2
    Conrad Carlberg

    Excel Sales Forecasting for Dummies, Wiley, 2005


    "Matrix Bill" <Matrix Bill@discussions.microsoft.com> wrote in message
    news:9A8F1995-A87C-4BDB-B8EB-40721BFC9D75@microsoft.com...
    > I am having a problem with matrix functions in general. No matter what
    > variation of sequences I use (the correct one included) I find that Excel
    > SOMETIMES only returns a portion of the result, one cell, the a11

    location.
    > It is clear that Excel is doing the calculation properly as it is

    displayed
    > in the fx window, when the result is an Identity matrix Excel returns a 1

    in
    > a11 location. I know that I have used the same sequence and procedure and
    > received different results.
    > I know I must be doing something wrong but cannot figure it out... help
    > please.
    > Bill




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1