How do I spread numbers over several months?

[soconfused]

I have a spreadsheet in which I am trying to take a number associated with a
date and spread that number over a certain # of months.

Total Hours Est. Close Ship Date Nov-08 Dec-08 Jan-09 Feb-09
160 10-17-08 9-18-09

So....what I need to do is take the 160 hours and 10% of that has to go into
the Sep-09 bucket and the rest has to be spread from the 10-17-08 date into
the next 3 months at 25% for the 1st month, 50% for the 2nd month and 15% of
the 3rd month.

The criteria are: hours <100 spread over 2 months at 40%, then 50%
hours 101-400 spread over 2 months at 25%, then
50%, then 15%

Any help would be GREATLY appreciated.

 

[Don Guillett]

Try this idea
=A3*(IF(A3<100,0.4,0.5))

 

[soconfused]

That would work if I were only working with one cell at a time, but I need to
be able to spread the 160 hours from the 10-17-08 date and put 10% of the 160
hours in Sep-08 from the 9-19-08 date.

 

[Don Guillett]

I said try this IDEA. Perhaps I am missing something. If desired, send your
wb to my addy below along with a very clear explanation and before/after
examples of what you want.