Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I spread numbers over several months? | Excel Discussion (Misc queries) | |||
Converting Numbers to Months | Excel Worksheet Functions | |||
In spread sheet the numbers entered as whole numbers become decim | Excel Worksheet Functions | |||
How to spread 15,000 into 12 months at 10% ? | Excel Worksheet Functions | |||
how do i create a spread sheet with randomly placed numbers 1-500. | Excel Discussion (Misc queries) |