View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel_Oz Excel_Oz is offline
external usenet poster
 
Posts: 11
Default 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