Thread: Return a value when the number is negative
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default 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.


Reply With QuoteReply With Quote