Matrix multiplication

Microsoft excel provides a function for matrix multiplication. Matrix multiplication process in microsoft excel accordance with the rules of the matrix. As with addition and pegurangan matrix. In our matrix multiplication is also doing an array of product from range of data. we will try to multiply two matrix (3x3 order)

1. Create a matrix as below (only accecories bracket, can be ignored)

2. Block range to put the product (adjusted order to the matrix results)
notes:
Order the product matrix = (mxn) (mxn) = (nxm)



3. Type the formula:
=MMULT(A4:C6,E4:G6)



Perform array by pressing the key combination Ctrl + Shift + Enter

4. The result will look like the image below

Related Posts by Categories

Microsoft Excel Tutorial

• Calculate body mass index (bmi formula) in excel 2007
• How to make a sine graph in excel 2007 (plot sine wave)
• Create cosine graph/plot cosine wave in excel
• How to find the matrix A if we known of Leontief matrix
• How to calculate Leontief matrix in excel
• How to calculate logarithm addition and logarithm multiplication in excel
• How to calculate logarithm reduction and log division in excel
• Calculate circumference of a circle in excel
• How to Calculate the Area of a Circle
• Feature Specification and Limits of Microsoft Excel 2007
• Microsoft Excel Tutorials
• What's new in Microsoft Office Excel 2007
• Calculate angles using the arcsin, Arccos, arctan in excel 2007
• Convert Decimal to Octal
• Convert Decimal to Binary
• Text function in excel 2003
• Error 16 digit number in excel 2003
• List of error or bug in excel 2003
• Fix Error RAND, RANDBETWEEN, SLOPE, INTERCEPT, FORECAST, and STEYX functions in Excel 2003
• Subtract matrix
• Counting the number of characters
• Choosing the existing text in brackets
• Power Function
• Function square root (square)

Matrix multiplication