Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating return for multiple separate time periods
How can I go about creating a formula that calculates the returns for strings
of positive returns? Sample data is below i.e. return for Jan-06 to Mar-06, Jun-06, and Aug-06 to Feb-07. (everytime column D0) thanks...trey Motnh Jan-06 1.37% 1 Feb-06 0.99% 2 Mar-06 0.12% 3 3 Apr-06 -0.45% 0 May-06 -0.18% 0 Jun-06 0.30% 1 1 Jul-06 -0.21% 0 Aug-06 0.38% 1 Sep-06 0.74% 2 Oct-06 0.37% 3 Nov-06 1.50% 4 Dec-06 1.40% 5 Jan-07 0.39% 6 Feb-07 1.44% 7 7 Mar-07 -0.09% 0 Apr-07 -0.74% 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Calls closed in Given periods | Excel Worksheet Functions | |||
Calculating overlapping time periods | Excel Worksheet Functions | |||
Calculating overlapping time periods | Excel Worksheet Functions | |||
Calculating overlapping time periods | Excel Worksheet Functions | |||
Calculating number of periods when payment amount changes | Excel Worksheet Functions |