A formula for IRR

[cyrille de brébisson]

Hello,

Easiest way to do it is as follow:

Enter your cashflow in L1, following usual +/- signs
enter the SOLVE aplet, but do NOT use the SOLVE UI as it will try to set L1 to 0..
Instead, on the command line, type:

SOLVE(ΣLIST(MAKELIST((L1(I)/X^(I-1)),I,1,SIZE(L1))),X)

This shold solve your IRR problem if I am not mistaken (verify the /X^(I-1), it might not be exactly what is needed)

Cyrille