Return a value when the number is negative

[Excel_Oz]

Hi,

I am wanting help on getting a formula to lookup column A and B. A has
numbers and B has dates.

I want a formula that will tell me when the amounts in Column A turn
negative for the first time.

Any help is appreciated.

Thanks

 

[Guest]

{=MIN(IF(A1:A65500<0,RÆKKE(A1:A65500)))}

{} means u have to type CTRL+SHIFT+ENTER



"Excel_Oz" skrev:

 

[Excel_Oz]

Thanks, but I couldnt get that one to work.

 

[Guest]

sry try this

{=MIN(IF(A1:A65500<0,ROW(A1:A65500)))}



"Excel_Oz" skrev: