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?