Hello all,

I am having a problem which may be simple to some. I working on a
financial analyis model and I have a cost item that needs to be spread
out over a certain amount of consecutive months (it can be either 3
months, 4 months, etc..) This cost can also start in any month. I am
having trouble defining the range for this formula. Whenever I use an
IF function it does not let me specify the range, only the first month
or the last month. I am using EDATE for my monthly headers and to
calculate the range in months. Any suggestions? Thanks


--
Cardan
------------------------------------------------------------------------
Cardan's Profile: http://www.excelforum.com/member.php...o&userid=36825
View this thread: http://www.excelforum.com/showthread...hreadid=565309