| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement ? Seperate cost over years of project
I have a series of data for projects with a project start date, a project end
date and a total amount for each project. I need to break the amount for each project down into years by the no of days the project ran in each of the years it ran (i.e. putting an amount under each year 2002, 2003, 2004). I am assuming an if statement breaking the amount down to a cost per day would be the way to go but am not sure how to go about getting data seperated for each year. -- Joy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to distribute/spread/map cost of project across different year | Excel Discussion (Misc queries) | |||
| IF STATEMENT HELP CHOOSE AND GET COST | Excel Worksheet Functions | |||
| Help create a IF statement to look to to seperate vookup data sour | Excel Worksheet Functions | |||
| URGENT IF STATEMENT REQUIRED:True if moving between financial years? | Excel Worksheet Functions | |||
| Current Cost versus Original Cost | New Users to Excel | |||
Threaded Mode
