| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up an APR calculation in Excel?
I would like to set up a spreadsheet template to calculate an Annual
Percentage Rate based on a series of cells containing the appropriate required parameters for this calculation. I am looking for the formula or serioes of formulas necessary to perfrom this calculation. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set up an APR calculation in Excel?
There are functions to do what you want, actually there are a lot of them.
Probobly the easiest one to use is Rate =RATE(Nper,DollorsAmt,NegAmt) Go to your functions and choose Financial and look for "Rate." The function is explained in "help." Just supply the amounts you desire to calculate in what ever cells you want and reference them in the formula. -- David "fritz17132" wrote: I would like to set up a spreadsheet template to calculate an Annual Percentage Rate based on a series of cells containing the appropriate required parameters for this calculation. I am looking for the formula or serioes of formulas necessary to perfrom this calculation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Calculation | Excel Discussion (Misc queries) | |||
| Excel IRR calculation | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| range.calculation with UDF not working when calculation is set to automatic | Excel Programming | |||
Hybrid Mode
