+ Reply to Thread
Results 1 to 2 of 2

Solving Matrix Multiplication without MMULT

  1. #1
    Registered User
    Join Date
    04-03-2019
    Location
    Salzburg
    MS-Off Ver
    office365
    Posts
    1

    Solving Matrix Multiplication without MMULT

    Hi,

    i need to Solve a Matrix Multiplication in VBA without MMULT
    123
    A = 456
    789


    B =10 20 30
    40 50 60
    70 80 90

    but i cant figure out how to do it.

    Please help :/

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,955

    Re: Solving Matrix Multiplication without MMULT

    With a requirement like "don't use the built in MMULT() function", this feels like an educational exercise, so I hesitate to just give code. What part of writing this are you having trouble with?

    1) If you are having trouble understanding the mathematical defintion of matrix multiplication, you might refer here or similar to refresh your understanding of matrix multiplication: https://www.mathsisfun.com/algebra/m...ltiplying.html In this case, among other things to note, the tutorial explains that matrix multiplication is not commutative (A*B will not always be the same as B*A). In your case, A*B is undefined, so that these two matrices can only be multiplied as B*A (just in case part of the problem is that you were trying to do A*B).
    2) I would expect that a proper matrix mutliplication procedure would involve a pair of nested For...Next loops at its core. Are you familiar with For...Next loops? What part of setting up a pair of nested For...Next loops are you having trouble with? A For...Next loop tutorial: https://www.wiseowl.co.uk/blog/s193/vba-for-next.htm
    How can we help you with this exercise?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Matrix Multiplication in VBA and storing values in another matrix
    By anwid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2018, 06:23 AM
  2. [SOLVED] Problem solving multiplication of two matrices with entries decimal
    By Milade8080 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2014, 02:34 AM
  3. matrix multiplication
    By Daniel CHEN in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 AM
  4. [SOLVED] matrix multiplication
    By Daniel CHEN in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  5. matrix multiplication
    By Carine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] matrix multiplication
    By Carine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. matrix multiplication
    By Carine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1