Tuesday, 28 July 2009

Matrix addition

 Microsoft excel provides a function to martix addition. Add process in accordance with the rules of the matrix, the matrix can be added if they have the same order.
Here we will try to add the matrix (4X4 order)

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



matrix addition

2. Block range to put the sum (adjusted the same order of a matrix that will add )



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

matrix

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

4. The result will look like the image below



No comments:

Post a Comment