I need a formula that tells me which year a project goes cashflow postive....
So lets says I have the following table:

A B
1 Year Cash
2 1 -100
3 2 -75
4 3 -25
5 4 50
6 5 200

So in the case above, I would want the formula to return Year 4 (A5) as that
is the first year the project goes cash flow positive.

Any ideas?

Thank you,

Try this array formula:

=INDEX(A2:A6,MATCH(MIN(IF(B2:B60,B2:B6,"")),B2:B6 ,0))

An array formula must be committed with CTRL-SHIFT-ENTER rather than just
enter. If done properly, the formula will be enclosed in { }.

HTH
Elkar


"Eli" wrote:

I need a formula that tells me which year a project goes cashflow postive....
So lets says I have the following table:

A B
1 Year Cash
2 1 -100
3 2 -75
4 3 -25
5 4 50
6 5 200

So in the case above, I would want the formula to return Year 4 (A5) as that
is the first year the project goes cash flow positive.

Any ideas?

Thank you,

I also found this formula to be helpful (which is also an array (need to
press ctrl+alt+shift): =INDEX(A2:A6,MATCH(TRUE,B2:B60,0))

"Eli" wrote:

I need a formula that tells me which year a project goes cashflow postive....
So lets says I have the following table:

A B
1 Year Cash
2 1 -100
3 2 -75
4 3 -25
5 4 50
6 5 200

So in the case above, I would want the formula to return Year 4 (A5) as that
is the first year the project goes cash flow positive.

Any ideas?

Thank you,