Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using IRR of Excel from VFP
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Using IRR of Excel from VFP
Miscellaneous
Thread ID:
00441774
Message ID:
00441774
Views:
50
I am doing o=create("excel.application")
and then o.sum(1,2) and getting 3

Other functions seem to work.
Trying to use IRR gives good results using an array of values aval:
dimension aval(6)
aval(1)=-70000
aval(2)=12000
aval(3)=15000
aval(4)=18000
aval(5)=21000
aval(6)=26000
lnvar=o.irr(@aval)
? lnvar gives .0866309480 which is correct, but when I try to do 3 years
dimension aval(3)
aval(1)=-70000
aval(2)=12000
aval(3)=15000
lnvar=o.irr(@aval,-10%)
? lnvar gives error message: missing operand

Any ideas?
Next
Reply
Map
View

Click here to load this message in the networking platform