Kč
-
Kč
$
$(
)
$-
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
€
-
€
€
-
€
€
-
€
€
-
€
-
-
€
-
€
- €
-
-
€
-
€
-
€
:
:
:
:
$
($
)
$
($
)
$
($
)
$
($
)
(
)
-
$
$
(
)
$
-
(
)
-
$
$
(
)
$
-
Yes
Yes
No
True
True
False
On
On
Off
€
(
€
)
\
\-
\
\-
\
\-
\
\-
\
\
-
\
-
-
-
\
\
-
\
-
-
-
-
-
-
-
-
-
€
-
€
.
/
€
-
€
⌀
$
-
$
(
)
-
$
$(
)
$-
(
)
-
$
€
-
€
.
.
WAHR
WAHR
FALSCH
$
-
$
€
-
€
€
-
€
руб.
-
руб.
R
R -
R
R -
R
R -
R
R -
-
-
R
R
-
R
-
-
-
R
R
-
R
-
ĝ
micron
mm
mm
Pa
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
(
)
(
)
(
)
-
(
)
-
(
)
-
(
)
-
.
.
:
:
:
.
.
:
-
-
-
-
€
-
€
€
-
€
€
-
€
€
-
€
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
MMULT Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple MMULT formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
0.2
1
0.01
1.01
2.01
19
19
TRUE
=MMULT({1,2;3,4},{5,6;7,8})
0.35
10.8
1.01
2.01
3.01
6.23
6.23
TRUE
=MMULT(I1:J2,I5:J6)
-3.15
5
2.01
3.01
4.01
6.23
6.23
TRUE
=I10
61.854
61.854
TRUE
=I11
3
6
11
12
13
3.2
3.2
TRUE
=J10
5.63
2
12
13
14
23.7
23.7
TRUE
=J11
2.3
-1
13
14
15
38.36
38.36
TRUE
=L10
74.36
74.36
TRUE
=L11
110.36
110.36
TRUE
=L12
6.23
3.2
38.36
41.39
44.42
41.39
41.39
TRUE
=M10
61.854
23.7
74.36
80.39
86.42
80.39
80.39
TRUE
=M11
110.36
119.39
128.42
119.39
119.39
TRUE
=M12
44.42
44.42
TRUE
=N10
86.42
86.42
TRUE
=N11
-0.0001
0.9999
1.9999
128.42
128.42
TRUE
=N12
-0.0002
0.9998
1.9998
7.9994
7.9994
TRUE
=I23
-0.0003
0.9997
1.9997
7.9988
7.9988
TRUE
=I24
7.9982
7.9982
TRUE
=I25
1
2
3
10.9991
10.9991
TRUE
=J23
2
3
4
10.9982
10.9982
TRUE
=J24
3
4
5
10.9973
10.9973
TRUE
=J25
13.9988
13.9988
TRUE
=K23
7.9994
10.9991
13.9988
13.9976
13.9976
TRUE
=K24
7.9988
10.9982
13.9976
13.9964
13.9964
TRUE
=K25
7.9982
10.9973
13.9964
Err:502
Err:502
TRUE
=MMULT(I1:J3,I5:J7)
4
O5
yes
1
no
2
yes
3