How to Subtract Matrices on Excel

••• Prostock-Studio/iStock/GettyImages

A matrix is a rectangular array of numbers. One matrix can be subtracted from another if it is of the same order -- that is, if it has the same number of rows and columns. Matrices are often used in statistics. Matrices are usually written surrounded by braces. Excel, the spreadsheet application included with Microsoft Office, refers to a matrix as an "array." It has built-in functionality to make working with matrices, or arrays, simple.

    Open Excel and enter the first matrix, starting in cell A1. The number of rows and columns you will depends on how your data is organized. For example, suppose the first matrix is: 3 2 1 4 6 8 In this case, you would enter "3" (without the quotation marks) in cell A1, "2" in cell B1, "1" in cell C1, "4" in cell A2, "6" in cell B2 and "8" in cell C2.

    Enter the second matrix. Skip one column and then enter the matrix in the same manner as the first matrix, but starting from your new column position. If the second matrix is: 1 1 1 2 3 4 You would enter "1" in cells E1, F1 and G1, and enter "2" in E2, "3" in cell F2 and "4" in cell G2.

    Highlight an area of blank cells of the same shape as the matrices. In this example, highlight cells I1 to K2.

    In the formula bar, enter =(top-left cell of array 1:bottom-right cell of array 1)-(top-left cell of array 2:bottom-right cell of array 2). Note the user of parentheses and colons. For the example given earlier, you would enter "=(a1:c2)-(e1:g2)" (without quotation marks).

    Press the Control, Shift and Enter keys simultaneously. (Excel requires that array formulas be entered using Control+Shift+Enter, rather than simply pressing Enter as you usually would.) Excel now enters the result in the highlighted cells.

Related Articles

How to Calculate Real Volumes in Excel
What Does ##### Mean in Excel?
How to Draw an Array in Math
How to Create Matrices on a TI-89
How to Calculate Pearson's R (Pearson Correlations)...
How to Solve 3-Variable Linear Equations on a TI-84
How to Calculate the Percent Change in Excel
How to Solve by Simpson's Rule With Excel
How to Calculate Correlation Coefficient Between Two...
How to Remove Duplicates in Two Rows in OpenOffice
How to Do Algebra in Excel
How to Determine If Matrices Are Singular or Nonsingular
How to Graph a Distribution for a T-Test
How Does Cytokinesis Differ in Plants & Animals?
How to Calculate Regression Coefficient
How to Find Linear Functions
How to Calculate Slope Using the TI-83 Plus
How to Do Sixth Grade Math Ratio Tables
How to Find Zeros of Functions in Excel
How Do I Calculate the Relative Standard Deviation...