LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 28
Default Reversing a column

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reversing the log Charli B Excel Discussion (Misc queries) 6 July 16th 08 11:11 AM
Need help reversing a formula... Larry Webb Excel Worksheet Functions 2 June 24th 08 05:26 PM
Reversing a column. How? [email protected] Excel Discussion (Misc queries) 5 December 21st 06 09:04 PM
Reversing date from column to Row [email protected] Excel Discussion (Misc queries) 3 September 8th 06 09:16 PM
Reversing First & Last Name Magic Excel Worksheet Functions 3 April 6th 05 08:18 PM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"