Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to take a column of calculated numbers and then reverse it .
I need to apply a compound interest factor. Using a 6% annual increase the value at the end of the first year is 1.06. The next year it is 1.1236 = 1.06^2 and so on. In this example I end up in Year 40 with a factor of 10.28571794. Then I need to reverse or flip this over so that the 10.28571794 is in the first year and it ends with the 1.06 on year 40. I'm stumped and would appreciate a helping hand. PY Age Compound int ToRetirement Compound int 1 26 1.06 40 10.28571794 2 27 1.1236 39 9.703507488 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reversing the log | Excel Discussion (Misc queries) | |||
Need help reversing a formula... | Excel Worksheet Functions | |||
Reversing a column. How? | Excel Discussion (Misc queries) | |||
Reversing date from column to Row | Excel Discussion (Misc queries) | |||
Reversing First & Last Name | Excel Worksheet Functions |