View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hejnoid hejnoid is offline
external usenet poster
 
Posts: 2
Default Need help in showing future purchases over a period of time and atset intervals

My problem is lets say I know I want to buy a total of A apples in
equal bunches until I have reached A. However these purchases will be
spread over time. Lets say I have months numbered from 1 to 100 in a
vertical column. I want to first be able to tell the function that I
want to purchase the apples in a certain number of bunches say X.
Then I want to say that my first purchase of apples will be made on
month Y with subsequent purchases made each Z months until I have
purchased a total of A apples. so I would like an output where in
column A I have months listed from 1 to 100 and in column B the number
of apples purchased in that month will be displayed. I anticipate most
months having an output of 0. Any ideas on how to tackle this one?