There has to be a formula for this....

[LSB M]

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 whe
payback comes, number becomes positive).

I want to know during which month the CUMULATIVE cashflow hits exactl
X dollars (say, $150K).

I know the second part of this solution uses a HLOOKUP. But wha
function can I use to tell it to sum "up to" $150K?

Thanks for any hints

 

[LSB M]

How can I tell it to deposit a value every "X" intervals?

e.g., I have 10 columns across. If I enter "2", every 2 columns,
want to insert a value (or formula)... If I enter "3", every 3 columns
a value (or formula) is inserted.

Any help will be greatly appreciated

 

[Ragdyer]

See answer in your later post.