Return a value when the number is negative

E

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
 
E

excelent

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

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



"Excel_Oz" skrev:
 
Top