Matrix multiplication: Difference between revisions
→{{header|Excel}}
Drkameleon (talk | contribs) (Added Arturo implementation) |
|||
Line 1,937:
end if
end function</lang>
=={{header|Excel}}==
Excel's MMULT function yields the matrix product of two arrays.
The formula in cell B2 here populates the '''B2:D3''' grid:
{{Out}}
{| class="wikitable"
|-
|||style="text-align:right; font-family:serif; font-style:italic; font-size:120%;"|fx
! colspan="8" style="text-align:left; vertical-align: bottom; font-family:Arial, Helvetica, sans-serif !important;"|=MMULT(F2#, F6#)
|- style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff;"
|
| A
| B
| C
| D
| E
| F
| G
| H
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 1
|
| colspan="3" style="font-weight:bold" | Matrix product
|
| style="font-weight:bold" | M1
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 2
|
| style="text-align:right; background-color:#cbcefb" | -7
| style="text-align:right" | -6
| style="text-align:right" | 11
|
| style="text-align:right" | 1
| style="text-align:right" | 2
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 3
|
| style="text-align:right" | -17
| style="text-align:right" | -20
| style="text-align:right" | 25
|
| style="text-align:right" | 3
| style="text-align:right" | 4
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 4
|
|
|
|
|
|
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 5
|
|
|
|
|
| style="font-weight:bold" | M2
|
|
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 6
|
|
|
|
|
| style="text-align:right" | -3
| style="text-align:right" | -8
| style="text-align:right" | 3
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 7
|
|
|
|
|
| style="text-align:right" | -2
| style="text-align:right" | 1
| style="text-align:right" | 4
|}
=={{header|F#}}==
| |||