Kč
-
Kč
(
)
-
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
€
-
€
-
€
/
/
/
/
€
-
€
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
-
-
-
-
-
-
Kč
-
Kč
- Kč
-
-
Kč
-
Kč
-
Kč
:
:
:
:
Yes
Yes
No
True
True
False
On
On
Off
¥€
(
€
)
€
-
€
%
/
/
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
MIRR Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple MIRR formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
-5
5
-5
-7500
-10000
18.74%
0.187362250932837
TRUE
=MIRR(I1:I5, 0.05, 0.08)
-10
10
3000
3400
7.04%
0.070394939660277
TRUE
=MIRR(J1:J4, 0.065, 0.1)
-15
15
5000
6500
7.04%
0.070394939660277
TRUE
=MIRR(J1:J4, , 0.1)
-8
8
1200
1000
2.91%
0.029142466571507
TRUE
=MIRR(J1:J4, 0.065, )
4000
2.91%
0.029142466571507
TRUE
=MIRR(J1:J4, 0.065, F6)
7.04%
0.070394939660277
TRUE
=MIRR(J1:J4, -0.065,0.1 )
-1.34%
-0.013378177510915
TRUE
=MIRR(J1:J4, 0.065, -0.1)
94.16%
0.941647376706893
TRUE
=MIRR(H1:H4,0.5,0.1)
Err:504
error
TRUE
=MIRR(, 0.065, 0.1)
Err:511
error
TRUE
=MIRR(H1:H4)
Err:511
error
TRUE
=MIRR(H1:H4,0.5)
Err:502
error
TRUE
=MIRR(G1:G4,0.51,0.1)
Values shall contain at least one positive value and at least one negative value.
Err:502
error
TRUE
=MIRR(F1:F4,0.51,0.1)
Tdf#100767 Values shall contain at least one positive value and at least one negative value.
7.04%
0.070394939660277
TRUE
=MIRR({-10000;3400;6500;1000}, 0.065, 0.1)
Tdf#58585
4