ExcelBanter - where is the formula for calculating the APR

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - where is the formula for calculating the APR (https://www.excelbanter.com/excel-discussion-misc-queries/60139-where-formula-calculating-apr.html)

slimcut

where is the formula for calculating the APR

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.

Scott Wagner

where is the formula for calculating the APR

Take a look at the RATE function in Excel help.

"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.

JE McGimpsey

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.

All times are GMT +1. The time now is 08:22 AM.