Re: How to Create Function for Matrix Multiplication
(Sites I've shared before) Quote links:
https://www.mrexcel.com/forum/excel-qu…iplication.html
http://www.vbaexpress.com/forum/showthre…1630#post361630
Re: How to Create Function for Matrix Multiplication
(Sites I've shared before) Quote links:
https://www.mrexcel.com/forum/excel-qu…iplication.html
http://www.vbaexpress.com/forum/showthre…1630#post361630
Re: How to Create Function for Matrix Multiplication
I'm sorry to break the rules.
I did something like that because of my time problem. Sorry again.
Do you want to delete my previous posts on this site?
If I have to ask for the responsibility differently. The function we will select is a range of matrices and we will add a number and multiply that number by the matrix.
Thank you for your reply.
Re: How to Create Function for Matrix Multiplication
Hi KjBox,
Ok, i added one excel file.
The file in the echo works as follows:
Command (example: = MatrixCarp (A1: C3; 2)), then the columns are multiplied by the number in k. But I want you to be independent of the k value and generally
multiply the matrix by the number value k such as the mmult command.
Thanks for your interest.
Hi,
I have some problem with function of MMULT in excel.
I want to do sample two matrix multiplication by MMULT function.
X matrix at a given interval and k is a function that multiplies the matrix for the value of the number.Many thanks for your help.
Example: Selected cells in the range A1 and C3, and Let k be the value of 3 (k=3).
=MatrixMultiply(A1:C3;3) -->> will give result
Function MatrixMultiply(X As Range, k As Integer) As Variant
.
.
.
End Function
‘---------------------------
‘Sample Use
‘-----------------------
Sub Test()
.
.
.
End Sub