| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need an Excel formula
I need an excel formula that will calculate the total sum of a number when
escalated by a fixed percentage rate over a variable number of years. My variables would be the initial cost and the number of years. the fixed number would be the 6% increase compounded each year. Can you help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need an Excel formula
=A2*(1+6%)^B2
-- David Biddulph "Paul G" <Paul wrote in message ... I need an excel formula that will calculate the total sum of a number when escalated by a fixed percentage rate over a variable number of years. My variables would be the initial cost and the number of years. the fixed number would be the 6% increase compounded each year. Can you help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need an Excel formula
Use the FV function, as in:
=FV(6%,a1,,-a2) Regards, Fred "Paul G" <Paul wrote in message ... I need an excel formula that will calculate the total sum of a number when escalated by a fixed percentage rate over a variable number of years. My variables would be the initial cost and the number of years. the fixed number would be the 6% increase compounded each year. Can you help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Linear Mode
