How do I do matrix subtraction in Excel?
1 Answer
As I use Linux as my operating system, I don't have Excel, so I'll use LibreOffice Calc to illustrate the matrix substraction procedure. This shouldn't be a problem, because the syntax is exactly the same as in Excel.
Consider the following two matrices:
Enter the matrices in your spreadsheet program as arrays of number cells separated by an empty column:
Next, select an array of empty cells of the same size as the given matrices (3 x 3) -- notice the orange selected area in the image below:
In the formula bar, write =(a1:c3)-(e1:g3) and press Ctrl-Shift-Enter (don't just press Enter, because it will not work). The result of the substraction will appear in the selected area I1:K3.