B
Burton Wilkins
What would be the syntax and namespace to be able to call
the VB function IRR?
the VB function IRR?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jay B. Harlow [MVP - Outlook]
Burton,
Reference the Microsoft.VisualBasic.dll.
The IRR function is in the Microsoft.VisualBasic.Financial class. Remember
that Modules in VB.NET are simply classes to C# with only static members.
Something like:
double[] valueArray = { -70000, 22000, 25000, 28000, 31000 };
double irr, guess = 0.1;
irr = Microsoft.VisualBasic.Financial.IRR(ref valueArray, guess);
Debug.WriteLine(irr.ToString("P"), "irr");
I'm really not sure why they defined the valueArray to be ref, I suspect
they translated the function literally from VB6. Rather then the intent of
the function.
Hope this helps
Jay
Reference the Microsoft.VisualBasic.dll.
The IRR function is in the Microsoft.VisualBasic.Financial class. Remember
that Modules in VB.NET are simply classes to C# with only static members.
Something like:
double[] valueArray = { -70000, 22000, 25000, 28000, 31000 };
double irr, guess = 0.1;
irr = Microsoft.VisualBasic.Financial.IRR(ref valueArray, guess);
Debug.WriteLine(irr.ToString("P"), "irr");
I'm really not sure why they defined the valueArray to be ref, I suspect
they translated the function literally from VB6. Rather then the intent of
the function.
Hope this helps
Jay