I am trying to break out a cost with multiple date ranges. For example,
I have a single cost of $120 that will be broken out into multiple
phases throughout the year. I would like to break this cost out into
phases that will occur with different ranges throughout the year. To
illustrate my example, please see below:

This is my setup and manual coding area: I apologize if the alignment
is off due to uploading..


Phase 1 Phase 2 Phase 3
Amount Beg Month End Month Beg Month End Month Beg Month
End Month
$120 Jan-07 Mar-07 May-07 May-07 Aug-07
Nov-07


Since there are a total of 8 months for this cost, I need to divide the
amount by 8 and then put them into the corresponding months. The end
product is to have the costs under the appropriate month, looking
something like this:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Nov Dec
$15 $15 $15 $15 $15 $15 $15 $15



I have the formula for calculating the total months and then it is just
a division problem for the amount per month. I am having problems
putting the ranges into one formula. Another issue is that I will end
up with around 10 phases so IF functions may not work since I can nest
only 7 "IF"'s. Is it possible to get this type of equation in one
line? The model is being built so all the $ Amount, Actual Beg-End
Months and the final $ under the month are all on the same row in the
same worksheet? Any suggestions? Thank you for your help. It is
greatly appreciated!