| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
APY and Interest rate calculation
What is the formula to have the interest rate change based on the APY? I
have amounts between 1000 to 10,000 with Interest rate and APY. When I change the APY I want it to calculate interest rate for all the fields with different amounts and APY with the new interest rate based on the new APY. How can I copy the same formula for all the other columns. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the interest rate. | Excel Worksheet Functions | |||
| What will be Rate of Interest (ROI) ? | Excel Worksheet Functions | |||
| to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
| APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
| Effective rate of Interest and Copounding Interest | Excel Worksheet Functions | |||
![boba[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
