IRR fuction

[Jamal]

Hi Friends,

I need your help please, I struggle with the IRR function, here is my  sql server table:

I want to calculate the the internal rate  (IRR) for each Projet. I ve used =RangeIRR($(vinvet),$(repeat(vpayment &',',$(vNumber-of-payment)))) but is not working. I need to get those variable from SQLServer and calculate the IRR. thank you very much

projet	invest	payment	Number-of- payment
A	-5000	200	12
B	-3000	600	25
C	-7000	500	36

[Jamal]

Hi Friends,

I need your help please, I struggle with the IRR function, here is my  sql server table:

I want to calculate the the internal rate  (IRR) for each Projet. I ve used =RangeIRR($(vinvet),$(repeat(vpayment &',',$(vNumber-of-payment)))) but is not working. I need to get those variable from SQLServer and calculate the IRR. thank you very much

projet	invest	payment	Number-of- payment
A	-5000	200	12
B	-3000	600	25
C	-7000	500	36