How do I spread numbers over several months?
 

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 a 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.

--
DMM

How do I spread numbers over several months?
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"soconfused" wrote in message
...
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 a 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.

--
DMM

How do I spread numbers over several months?
 

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.
--
DMM


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"soconfused" wrote in message
...
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 a 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.

--
DMM

How do I spread numbers over several months?
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"soconfused" wrote in message
...
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.
--
DMM


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"soconfused" wrote in message
...
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 a 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.

--
DMM