Thursday, 30 July 2009

Subtract matrix

Microsoft excel provides a function to subtract martiks. Matrix reduction process in accordance with the rules of the matrix, the matrix can be deducted if it has the same order.
Here we will try to subtract two matrix (order 4x4)

1. Create a matrix as below (only accecories brackets, can be ignored)

2. Block range to put the results of reduction (adjust the order of the matrix that will be deducted)

3. Type the formula:
= A4: C7-E4: G7

Perform array by pressing the key combination Ctrl + Shift + Enter

4. The result will look like the image below

Related Posts by Categories

No comments:

Post a Comment

Random Posts