| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if argument?
I am compiling a capital purchase forecast over five years togther with
forecast depreciation. The top of my spread sheet has months 1 through to 60. I would like to calculate purchases in year 1, namely if it occurred between months 1 and 12, similarly calculate purchases in year 2 ( occurring between month 13 and 24) etc. Column A2:A20 has a list of proposed assets, column B2:B20 their purchase cost and column C2:C20 the proposed month of expenditure (1-60). Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| countif greater/less than argument | Excel Worksheet Functions | |||
| How do I set up an argument which asks for multiple criteria | Excel Discussion (Misc queries) | |||
| text argument in vlook up which has a "" | Excel Worksheet Functions | |||
| read in Vlookup an argument that has quotations(") | Excel Discussion (Misc queries) | |||
Threaded Mode
