next up previous contents index
Next: MOD Up: A. Function Reference Previous: MIRR   Contents   Index


MMUL

Syntax: MMUL(M1, M2)

M1 = a matrix
M2 = a matrix

MMUL generates the product of the multiplication of matrix M2 by matrix M1. If the dimensions of the matrices are incompatible, the function generates an error.

Examples:

Matrix B9..C10 =

  B C
9 0 1
10 1 2
     

Matrix D9..E10 =

  D E
9 3 5
10 4 8
     

MMUL(B9..C10, D9..E10) =
4 8
1 21

Matrix A1..B3 =

  A B
1 0.99 0
2 3 6.2
3 4.1 1.1
     

Matrix C1..E2 =

  C D E
1 0.5 0.85 3
2 0.2 0.4 5
       

MMUL(A1..B3, C1..E2) =
0.495 0.8415 2.97
2.74 5.03 40
2.27 3.925 17.8

MMUL(A1..B3, C1..G10) = Error - incompatible matrix dimensions

Excel function: MMULT


next up previous contents index
Next: MOD Up: A. Function Reference Previous: MIRR   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003