Thread
:
How do I spread numbers over several months?
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett