Return a value when the number is negative
 

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

Return a value when the number is negative
 

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

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



"Excel_Oz" skrev:

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

Return a value when the number is negative
 

Thanks, but I couldnt get that one to work.

Return a value when the number is negative
 

sry try this

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



"Excel_Oz" skrev:

Thanks, but I couldnt get that one to work.