Syntax: DOT(R1, R2)
R1= a vector
R2 = a vector
DOT returns the dot product of two vectors. R1 must have the same number of rows and columns as R2, or R1 and R2 can be one-dimensional vectors of the same length.
Examples:
Matrix 1, A1..B2 =
A | B | |
1 | 1 | 3 |
---|---|---|
2 | 2 | 4 |
Matrix 2, C1..D2 =
C | D | |
1 | 9 | 5 |
---|---|---|
2 | 2 | 4 |
DOT(A1..B2, C1..D2) =44
DOT(A1..B1, C1..C2) = 15
DOT(A1..B2, D1..D2) = Error - DOT, incompatible range dimensions
Excel function: N/A