Hi guys, need some help here...
I have 120 colums across, each representing a month.. (month 1-120).
Each month has a dollar value (starts off mostly negative, then when
payback comes, number becomes positive).
I want to know during which month the CUMULATIVE cashflow hits exactly
X dollars (say, $150K).
I know the second part of this solution uses a HLOOKUP. But what
function can I use to tell it to sum "up to" $150K?
Thanks for any hints.
--
LSB M
------------------------------------------------------------------------
LSB M's Profile:
http://www.excelforum.com/member.php...o&userid=36258
View this thread:
http://www.excelforum.com/showthread...hreadid=562135