Break even points

[Paul Bond]

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?

 

[Toppers]

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

 

[Paul Bond]

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]

try:

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

Entered with Ctrl+Shift+Enter

HTH