| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Hybrid Mode
