Syntax<\/h3>\n
MMULT(matrix1, matrix2)<\/strong><\/p>\n Please note that the columns in\u00a0<\/span>matrix1<\/strong>\u00a0<\/span>must be equal to the rows in\u00a0<\/span>matrix2<\/strong>. This is a\u00a0rule of standard in any matrix multiplication.<\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We will certainly need the help of a few practical examples to clearly understand the usage of this formula. So, let\u2019s get our hands dirty in applying this in practice. Please consider the following snapshot. For the purposes of illustration, please consider the values within the range\u00a0<\/span>A2:B4<\/strong>\u00a0<\/span>for\u00a0<\/span>matrix1<\/strong>, and the values in the range\u00a0<\/span>A7:C8<\/strong>\u00a0for\u00a0<\/span>matrix2<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/MMULT-formula-Illustration-Frame-1.png” alt=”MMULT Google Sheets” title_text=”mmult-formula-google-sheets” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We\u2019ve keyed in the first formula within the cell E3. We see that the output data flow from E3 towards the right and then further down. That is because the output of a matrix multiplication is a multidimensional array. So, it is very important that we keep the cells, where we expect the data to flow, clear of any values. Otherwise, the formula returns #REF! error.<\/p>\n In the first example, we used direct arrays using a pair of curly braces. We separated the values into columns and rows using commas and semi-colons respectively.\u00a0In the second example, we used references to the ranges of cells that contain the values we used in the first example. Regardless of the input methods, we essentially used the same input values. That is the reason why we see the exact same output in both the examples.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Spreadsheets have come a long way since they were first available, thereby making our lives a lot easier. Today they provide us with a myriad of tools and formulas, which will help us with most of our mathematical and statistical calculations. Therefore, it is no surprise that we have\u00a0MMULT\u00a0formula in Google Sheets to help us […]<\/p>\n","protected":false},"author":40,"featured_media":9033,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Spreadsheets have come a long way since they were first available, thereby making our lives a lot easier. Today they provide us with a myriad of tools and formulas, which will help us with most of our mathematical and statistical calculations. Therefore, it is no surprise that we have MMULT<\/a> formula in Google Sheets to help us calculate the product of two matrices.\n\n
Usage: MMULT formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nMMULT(matrix1, matrix2)<\/strong>\n
\n \t
Usage: MMULT formula in Google Sheets<\/h3>\nWe will certainly need the help of a few practical examples to clearly understand the usage of this formula. So, let's get our hands dirty in applying this in practice. Please consider the following snapshot. For the purposes of illustration, please consider the values within the range A2:B4<\/strong> for matrix1<\/strong>, and the values in the range A7:C8<\/strong> for matrix2<\/strong>.\n\n
![\"MMULT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/MMULT-formula-Illustration-Frame-1.png\")
\n\nWe've keyed in the first formula within the cell E3. We see that the output data flow from E3 towards the right and then further down. That is because the output of a matrix multiplication is a multidimensional array. So, it is very important that we keep the cells, where we expect the data to flow, clear of any values. Otherwise, the formula returns #REF! error.\n\nIn the first example, we used direct arrays using a pair of curly braces. We separated the values into columns and rows using commas and semi-colons respectively. In the second example, we used references to the ranges of cells that contain the values we used in the first example. Regardless of the input methods, we essentially used the same input values. That is the reason why we see the exact same output in both the examples.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-9032","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=9032"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9032\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/9033"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=9032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=9032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=9032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}