Find First Negative Number after 'X' has been reached

[dwg1803]

Hello All, i am in a pinch.

I have read several threads and the content looks great. I just haven't found a solution for my challenge yet.

Here it is, any insight would be greatly appreciated.

my screen shot: 2014-09-05_1302 - willgrimmer's library

I have 8 cells in columns A-H in Row 3. their contents are

-5, 5, -2, 4, -2, 10, 4, 11

in Cell K1 = 3

I need a formula that will tell me which position in Row 3; where after the value in K1 has been exceeded, I need the position of the next time i have a value of less than or equal to "Zero". Looking at the data, the answer should be "3", but I am having a hard time using "Match" and "Index" and "ISNA" formulas that are not working.

Any insight would be Greatly Appreciated.

thanks in advance.


Will

 

[mikerickson]

^ Yes, it uses the same principle. One CSE to find the first greater-than cell. Use that to define the range and find the first negative.