# 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.