IRR function in VBA

[meena]

I am using Internal Rate of Return(IRR) function to
calculate yields in VBA. The result will be printed in
excel sheet. I get an runtime error message "Invalid
Proceure call or argument".
The code I have is
yield=IRR(irrArray(),0.03)
irrArray consists of
-1000 (48 times)
48441.18 (49th index)
I tried to change the guess from 0.03 to 0.01 and still it
doesn't work for some of my arrays.
I would appreciate any help regarding this issue.
Thanks
Meena

 

[Tushar Mehta]

Since you haven't shared the code, it is hard to know what exactly is
wrong.

Using 0.01 as the guess returns a value of 0.000372964430338515

My *guess* is that you are so close to zero that the result becomes
very sensitive to guess.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions