Perform matrix arithmetic

Calc > Matrices > Arithmetic

Perform arithmetic operations on matrices, columns, and stored constants or numbers.

  1. Select the type of arithmetic to perform: Add, Subtract, or Multiply.
  2. Enter the matrices, columns, stored constants, or numbers. The dimensions of the items that you enter must be compatible. For example, you can add only matrices that have the same dimensions.
  3. In Store result in, enter a number for the matrix, column, or constant (for example, M1, C1, or K1), or enter a column name. If the name contains spaces, enclose the name in single quotation marks.

For example, if you add M1 and M2 together, the result is M3.

1 2 3
4 5 6
7 8 9
M1
11 22 33
44 55 66
77 88 99
M2
12 24 36
48 60 72
84 96 108
M3