Break even points
 

Is there a way to locate the breakeven point in a row of data and then return
a value from the same column where the breakeven point occurs?

Break even points
 

Example of data might help to understand what you mean by "breakeven point".

"Paul Bond" wrote:

Is there a way to locate the breakeven point in a row of data and then return
a value from the same column where the breakeven point occurs?

Break even points
 

A B C D E F G H I
J K
1 Number of people 2 4 6 8 10 12 14 16 18 20
2 Profit -10 -5 -2 1 3 5 10 15 25
40

I want to locate at which point the profit turns from -ve to +ve (cell E2)
and then return the number of people (8, cell E1)

Thanks

"Toppers" wrote:

Example of data might help to understand what you mean by "breakeven point".

"Paul Bond" wrote:

Is there a way to locate the breakeven point in a row of data and then return
a value from the same column where the breakeven point occurs?

Break even points
 

try:

=INDEX(B1:K1,0,MATCH(TRUE,(B2:K20),0))

Entered with Ctrl+Shift+Enter

HTH

"Paul Bond" wrote:

A B C D E F G H I
J K
1 Number of people 2 4 6 8 10 12 14 16 18 20
2 Profit -10 -5 -2 1 3 5 10 15 25
40

I want to locate at which point the profit turns from -ve to +ve (cell E2)
and then return the number of people (8, cell E1)

Thanks

"Toppers" wrote:

Example of data might help to understand what you mean by "breakeven point".

"Paul Bond" wrote:

Is there a way to locate the breakeven point in a row of data and then return
a value from the same column where the breakeven point occurs?