Excel question with if statements

  • Thread starter Thread starter kidflip
  • Start date Start date
K

kidflip

Hi Everyone:

I have a monthly financial projection model and I am trying to build
the following functionality.

One assumption is that there will be an acquisition in any given month.
For this I have set it up so when a person enters the month on the
assumptions chart there is an if statement in the projections sheet
that enters the amount in the proper month. However as soon as the
acquisition takes place I have a series of 12 (one each month) capital
expenditures that take place below in the expenditures row. How do I
build the functionality so that as soon as the acquisition date is
entered in the capital expenditures line there is a series of 12
payments immediately following the month of the acquisition.


Thanks very much in advance for your help on this and HAPPY NEW
YEAR!!!!:)
 
You might attach a sample of what you have and add some notes as
to what you want.
Click to expand...

You should learn that excelforum is just a frot-end on USENET newsgroups,
and while excelforum provides a nonintrusive means of attaching files, most
newsreaders actually include attached files in the newsgroup posting, and
files should NEVER be attached to messages in nonbinary newsgroup postings.

Besides, all formula/function questions can be resolved in plain text if the
OP takes the time to provide all details.
 
Back
Top