|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 9th, 2006, 06:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function
I have a construction schedule with the budget to be drawn out over time. My
cells are set up as follows: # of Months Start Month End Month Amount Jan-06 Feb-06 March 06 3 1/01/06 3/31/06 $100,000 How do I create a function so that when someone inputs in the number of months and start and end months, the appropriate amount is allocated over the necessary months? Thanks. 
|
|
#2
January 9th, 2006, 06:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date function
Assuming months in A2 and TotalAmount in D2.....put this formula in each
month in row 2, and copy down as appropriate....... =$D2/$A2 Vaya con Dios, Chuck, CABGx3 "918" wrote: I have a construction schedule with the budget to be drawn out over time. My cells are set up as follows: # of Months Start Month End Month Amount Jan-06 Feb-06 March 06 3 1/01/06 3/31/06 $100,000 How do I create a function so that when someone inputs in the number of months and start and end months, the appropriate amount is allocated over the necessary months? Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
| Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
| Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
| Calendar Object | Steve | Setting Up & Running Reports | 1 | May 18th, 2004 04:44 PM |
| freezing todays date in a function | Dave | Worksheet Functions | 7 | January 18th, 2004 12:52 AM |
Linear Mode
