View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default where is the formula for calculating the APR

Did you search for "rate" in XL Help?

Take a look at EFFECT(), NOMINAL(), and RATE(). Note that EFFECT() is an
Analysis Toolpak Add-in function (Tools/Add-ins...).

In article ,
"slimcut" wrote:

Financial credit agreements display the rate in terms of APR (the Annual
Percentage Rate). There is an IT formula usually embedded in spreadsheet
software. I cannot find it. Where is it located.