Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation without Excel
Message
From
21/05/2008 13:53:46
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01318841
Message ID:
01318846
Views:
10
>I tried asking is question once upon a time and no one could convert it that is why I choose to call excel now I have a user who does not have excel so we just ignore the calc but they really want to know.
>
>It is calculating an equivalent rate.
>
>=RATE($A$1,-(($B$1+C1)/$A$1),$B$1)*12
>
>A = Term
>B = LoanAmt
>C = Interest
>
>D = EquivRate.
>
>Give it a shot....

Is equiv.xls exists?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform