2016-08-02T18:25:37.357529091P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/389b08190092f9a9103b3ac098994ec83b2d0bfa
0
0
69019
15019
view1
2
8
0
0
0
0
2
0
0
0
0
0
80
60
true
false
9
28
0
0
0
0
2
0
0
0
0
0
80
60
true
false
Sheet2
1241
0
80
60
false
true
true
true
12632256
true
true
true
true
false
false
false
1270
1270
1
1
true
false
7
false
false
true
true
false
false
false
1270
1270
true
true
true
true
true
false
12632256
false
Lexmark-E352dn
en
US
fr
FR
ru
RU
true
true
3
1
true
1
true
qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=
false
0
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
MINVERSE Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple MINVERSE formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
Data
0.2
1
-0.9
1
2
3
1
Data
0.011363636363636
0.011363636363636
TRUE
=MINVERSE(I2:L5)
1
3
8
5
0.35
10.8
4
4
5
6
1
4
-1
2
2
TRUE
=MINVERSE({3,6,1;1,1,0;3,10,2})
1
3
6
1
-3.15
5
7
8
9
1
2
0
-0.333333333333333
-0.333333333333333
TRUE
=MINVERSE({3,6;1,1})
1
0
Formula
Description
Results
Err:502
Err:502
TRUE
=MINVERSE({1,3,8,5;1,3,6,1})
7
3
10
2
0
0.5
5.96685082872928
5.96685082872928
TRUE
=MINVERSE(N1:O2)
-1
2
#VALUE!
#VALUE!
TRUE
=MINVERSE(N1:P3)
-2
-2
TRUE
=MINVERSE({1,2;3,4})
-2
-2
TRUE
=MINVERSE({1,2,1;3,4,2;1,1,2})
Err:502
Err:502
TRUE
=MINVERSE(R1:T3)
Err:502
Err:502
TRUE
=MINVERSE(V1:X3)
1
-0.00015625
0
0.22658062230748
0.226580622307481
TRUE
=I18
0
1
-6.92520775623269E-06
-4949.88401723213
-4949.88401723212
TRUE
=I19
1
-0.0001108033241
-1
0.0001108033241
-0.051669615021659
-0.051669615021659
TRUE
=I20
-5.86486486486487E-12
-1.3466097676624E-15
3.42028985507246E-12
6.91584032545131E-16
-7461.09240912761
-7461.09240912761
TRUE
=I21
0.625136818699551
0.62513681869955
TRUE
=J18
4000.87563967713
4000.87563967712
TRUE
=J19
1.05454490009909
1.05454490009909
TRUE
=J20
0.22658062230748
0.625136818699551
0.417669536993637
-60657806939.4408
7876.28357430792
7876.28357430793
TRUE
=J21
-4949.88401723213
4000.87563967713
2673.08503675928
-388209964412421
0.417669536993637
0.417669536993637
TRUE
=K18
-0.051669615021659
1.05454490009909
0.058567811378701
1176190162.26062
2673.08503675928
2673.08503675928
TRUE
=K19
-7461.09240912761
7876.28357430792
8457.19196308448
169841859430434
0.058567811378701
0.058567811378701
TRUE
=K20
8457.19196308448
8457.19196308448
TRUE
=K21
-60657806939.4408
-60657806939.4408
TRUE
=L18
-388209964412421
-388209964412421
TRUE
=L19
1176190162.2606200000
1176190162.2606200000
TRUE
=L20
169841859430434
169841859430434
TRUE
=L21
!
0
0
TRUE
=Z5
-1
-1
TRUE
=Z6
0.5
0.5
TRUE
=AA5
2
2
TRUE
=AA6
Err:511
error
TRUE
=MINVERSE()
4
O5
yes
1
no
2
yes
3