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