>>>Does anyone know where to find the calculation for the interest rate if you have Present Value, Term, & Payment Amount?
>>
>>VFP has PAYMENT(). You can use automation to Excel to get most any financial funciton you need.
>
>Hey Craig,
>Wouldn't automation be a little slow just to figure out one calculation? I have only used Word automation and it's not exactly quick. What do you think?
Yes, it would be slow. You can look at Excel help. Some of the calculations are explained there. At Franklin, I had to figure out the calculation for charging interest, which is based on a 360-day calendar. I found lots of good info in Excel Help.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer