Question: A function should work as a generic matrix multiplication function, whilst also achieving the following tasks: It should be able to take in ANY 2

A function should work as a generic matrix multiplication function, whilst also achieving the following tasks: It should be able to take in ANY 2 matrices and multiply them if they conform. The process should use MessageBox Error if the Matrices do not work, and output the error code to the cell: "NC-ERR" The error code should appear in every cell in the designated green output area. For any given dot product the matrix conducts, it should also achieve the following: - Convert all the numbers in the second matrix to positive (absolute) values. - Replace any number in the first matrix that is greater than 5 with 5 - Replace any number in the second matrix that's magnitude is over 6 with 0 - If the final dot product result is greater than 10, replace the output with the string "BIG"

How could I write code using the VBA function?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!